[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Re: converting 1min data to other timeframes



PureBytes Links

Trading Reference Links

Lionel -

Folowing the instructions that were given exactly:

1. Open the chart of the 1 min data
2. Change to the desired output time frame (eg 1 minutes)
3. Select the price data plot and then copy it.
4. Paste into an Excel spreadsheet.
5. Save as a CSV file.

If you try to use the Downloader immediately after the last step, the 
saved file is still open in Excel. I believe the Downloader has a 
problem with that. If you save as csv and then quit Excel (as step 
6), you are certain the file isn't still open. The Downloader works 
on the inactive file.

Regards,
Ron

--- In equismetastock@xxxxxxxxxxxxxxx, "Lionel Issen" <lissen@xxx> 
wrote:
>
> When are you supposed to exit from Excel?
> 
> When an excel page is opened, Excel also opens.
> 
>  
> 
> Lionel
> 
>  
> 
> From: equismetastock@xxxxxxxxxxxxxxx 
[mailto:equismetastock@xxxxxxxxxxxxxxx]
> On Behalf Of rsb_44
> Sent: Thursday, March 06, 2008 12:13 PM
> To: equismetastock@xxxxxxxxxxxxxxx
> Subject: [EquisMetaStock Group] Re: converting 1min data to other 
timeframes
> 
>  
> 
> Have you closed out of Excel? Try that, if you haven't.
> 
> --- In equismetastock@xxxxxxxxxxxxxxx
> <mailto:equismetastock%40yahoogroups.com> , dirk_boodts <no_reply@> 
> wrote:
> >
> > 
> > This is indeed a nice way to do the trick but when I save it as 
CSV 
> > and try to convert it in the downloader (version 8.0) it gives an 
> > error (cannot open file) or it just shuts down without result. 
> > 
> > Is it a special format of CSV? it's just DOS no? with all the 
popup 
> > warnings when trying to save.
> > Or can it be just in excel format? (although i tried and it 
didn't 
> > worked either)
> > 
> > Somebody had the same probs? Somebody with who it is working 
great?
> > 
> > 
> > rgds,
> > dirk
> > 
> > 
> > 
> > 
> > 
> > --- In equismetastock@xxxxxxxxxxxxxxx
> <mailto:equismetastock%40yahoogroups.com> , "Tim" <prez@> wrote:
> > >
> > > If it is already in M/S format, then simply use MS to do all 
the 
> > hard work
> > > for you.
> > > 
> > > The way to do this.
> > > 1. Open the chart of the 1 min data
> > > 2. Change to the desired output time frame (eg 1 minutes)
> > > 3. Select the price data plot and then copy it.
> > > 4. Paste into an Excel spreadsheet.
> > > 5. Save as a CSV file.
> > > 
> > > Repeat the above steps for any other time frames.
> > > 
> > > Cheers,
> > > Tim.
> > > _____ 
> > > 
> > > From: equismetastock@xxxxxxxxxxxxxxx
> <mailto:equismetastock%40yahoogroups.com>  
> > [mailto:equismetastock@xxxxxxxxxxxxxxx
> <mailto:equismetastock%40yahoogroups.com> ]
> > > On Behalf Of hanmanman2000
> > > Sent: Tuesday, 28 June 2005 00:50
> > > To: equismetastock@xxxxxxxxxxxxxxx
> <mailto:equismetastock%40yahoogroups.com> 
> > > Subject: [EquisMetaStock Group] converting 1min data to other 
> > timeframes
> > > 
> > > I was wondering if some sort of a tool exists to convert 1min 
> data 
> > to
> > > other timeframes (e.g. 10 min, hourly). I'm aware of the fact 
that
> > > Metastock does this automatically when choosing a different 
> > timeframe
> > > for a chart, and that various indicators have been developed as 
> > well,
> > > but I want to convert at the level of the raw data (i.e. as it 
> > shows
> > > up in the downloader).
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > _____ 
> > > 
> > > YAHOO! GROUPS LINKS 
> > > 
> > > * Visit your group "equismetastock
> > > <http://groups.yahoo.com/group/equismetastock> " on the web.
> > > 
> > > * To unsubscribe from this group, send an email to:
> > > equismetastock-unsubscribe@xxxxxxxxxxxxxxx
> <mailto:equismetastock-unsubscribe%40yahoogroups.com> 
> > > <mailto:equismetastock-unsubscribe@xxxxxxxxxxxxxxx
> <mailto:equismetastock-unsubscribe%40yahoogroups.com> ?
> > subject=Unsubscribe> 
> > > 
> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
> > Service
> > > <http://docs.yahoo.com/info/terms/> . 
> > > 
> > > _____
> > >
> >
> 
>  
> 
> 
> 
> [Non-text portions of this message have been removed]
>




 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/