|
PureBytes Links
Trading Reference Links
|
Hi Walter,
I have been reading Excel related posts with great interest. As far as
part "a" goes here is how I do it:
I run this web query
http://quote.yahoo.com/d/quotes.csv?s=AMAT+AMGN+AOL+WMT&f=sl1d1t1c1ohgv&e=.
csv
It will deposit quotes into my spreadsheet (text format). A simple macro
converts text into columns and re-arranges the columns the way I like them.
>From this point on I can transfer each quote to it's appropriate historical
file or whatever.
It's crude, but dependable.
Fred
|