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

[EquisMetaStock Group] Re: Inserting Data in the Downloader Much simpler version!!



PureBytes Links

Trading Reference Links

The page given

http://www.economagic.com/em-cgi/data.exe/feddal/hsm

has the data in a table which is inconsistantly formatted. 
How does one get from the table to a .csv file?

BTW Making the Lite version available for free is a real service to 
the Excel/Metastock community. Thank you.

--- In equismetastock@xxxxxxxxxxxxxxx, "L. Carhartt" <lc@xxx> wrote:
>
> By the way, I should add, the plug-in will only plot lines and 
histograms.
> For price charts (bar, candlestick charts, etc.) you do need to use
> MetaStock format price files.
>  
> Best,
> 
> L. P. Carhartt
>  
> 
> -----Original Message-----
> From: equismetastock@xxxxxxxxxxxxxxx 
[mailto:equismetastock@xxxxxxxxxxxxxxx]
> On Behalf Of rsb_44
> Sent: Wednesday, January 30, 2008 6:42 AM
> To: equismetastock@xxxxxxxxxxxxxxx
> Subject: [EquisMetaStock Group] Re: Inserting Data in the 
Downloader Much
> simpler version!!
> 
> 
> 
> In Excel Pute the word DATE in A1
> in A2 and below put the correct date in mm/dd/yyyy format
> In B1 Put the word CLOSE
> in B2 and below put the value for the starts. Beware of the hidden 
> characters in the table.
> Save the file as an .xls file
> Convert the file with the Downloader. (It's help file says how)
> Follow the rest of the instructions from the prior message.
> 
> Sorry for the earlier message. It is actually a very simple way 
with 
> consistantly formatted data.
> 
> --- In equismetastock@ <mailto:equismetastock%40yahoogroups.com>
> yahoogroups.com, "rsb_44" <rsb_44@> wrote:
> >
> > This isn't a simple task as the data isn't consistantly 
formatted. 
> In 
> > fact copying it by hand doesn't work as some of the data is 
hidden.
> > 
> > If you know Excel, the broad outline is:
> > 1. Copy the data into Excel (The usual click , shift click copy 
> paste
> > 2. Parse the data in Excel
> > 3. Assemble a date
> > 4. Convert the date to the format the Downloader accepts
> > 5. Carry the actual starts to it's own column.
> > 6. Lable the date column DATE and the Data Column CLOSE 
> > 7. Convert the data using the Downloader (You'll have to supply a 
> > ticker ID)
> > 8. Create an indicator MyClose (It's simply C, but used as an 
> > indicator.)
> > 9. Open the ticker
> > 10.Make the plot the same color as the background.
> > 11. Apply the myclose indicator use the histogram style.
> > 
> > You wind up with a chart showing housing starts a series of 
columns 
> > much like a volumn chart
> > 
> > Is that what you want?
> > 
> > 
> > 
> > --- In equismetastock@ <mailto:equismetastock%40yahoogroups.com>
> yahoogroups.com, "Alex Spiroglou" 
> > <a.spiroglou@> wrote:
> > >
> > > I would appreciate your help on this please...
> > > 
> > > I would like to chart "Housing Starts" in Metastock.
> > > I found the data through Economagic
> > > http://www.economag
> <http://www.economagic.com/em-cgi/data.exe/feddal/hsm>
> ic.com/em-cgi/data.exe/feddal/hsm
> > > 
> > > How could I insert the data in the Downloader ?
> > > 
> > > 
> > > thank you in advance
> > > Alex Spiroglou
> > > 
> > > 
> > > P.S. I would like to chart data from 2000 and on,
> > > so I would not even mind to do it manually
> > > 
> > > 
> > > [Non-text portions of this message have been removed]
> > >
> >
> 
> 
> 
>  
> 
> 
> 
> [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/