|
PureBytes Links
Trading Reference Links
|
Sorry for the delay. I was making (and then eating) breakfast.
I had the web page data you supplied basically converted to.csv then started
thinking that I knew there had to be a better way. Converting a web page to
.csv is not particularly difficult, but can be time consuming when done
manually. Most of the (index & ETF) constituent lists we gather nightly are
parsed out of web pages automatically so I am more than familiar with the
process.
Anyway, try this link instead for an already put together .csv file:
http://research.stlouisfed.org/fred2/series/HOUST/
Under the black headline, click on "Download Data". Scroll down the new
page and select "Text, comma separated" and then click on "Download Data".
Not only is this site THE original source for similar historic data, but it
is also free. The file provided is easily displayed in MetaStock using the
MetaStockCSV Plug-in or, if you are a glutton for punishment, converted to
MetaStock price format files and used that way.
Best,
L. P. Carhartt
-----Original Message-----
From: equismetastock@xxxxxxxxxxxxxxx [mailto:equismetastock@xxxxxxxxxxxxxxx]
On Behalf Of rsb_44
Sent: Wednesday, January 30, 2008 7:45 AM
To: equismetastock@xxxxxxxxxxxxxxx
Subject: [EquisMetaStock Group] Re: Inserting Data in the Downloader Much
simpler version!!
The page given
http://www.economag <http://www.economagic.com/em-cgi/data.exe/feddal/hsm>
ic.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@ <mailto:equismetastock%40yahoogroups.com>
yahoogroups.com, "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@ <mailto:equismetastock%40yahoogroups.com>
yahoogroups.com
[mailto:equismetastock@ <mailto:equismetastock%40yahoogroups.com>
yahoogroups.com]
> On Behalf Of rsb_44
> Sent: Wednesday, January 30, 2008 6:42 AM
> To: equismetastock@ <mailto:equismetastock%40yahoogroups.com>
yahoogroups.com
> 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.economag
<http://www.economagic.com/em-cgi/data.exe/feddal/hsm>
ic.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]
>
[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/
|