Downloading yahoo EOD prices

[fielman]

Quote from xperttrader:

FYI, candlestick charting added to new version. Very handy tool.

Very handy tool!

Do you perhaps know how to get the data and more specifically the Adj. Close field into Excel?

Thanks

 

[rebtut]

Quote from xperttrader:

Hello!

fwiw,

there in attachment you can download app I was talking about,
it is a simple script;
- it loads ticker data from stocks.txt (you need to edit it and put custom symboly )
-fetches data from nasdaq web page (splits adjusted)
-saves in xls (actually txt) file
-if earlier data was already downloaded, just append fresh data to the end of file

(you need rebol/view to use it, download from www.rebol.com)

(in attachment I put stocks from DJIA, if you need list for nasdaq or amex or all nyse stocks, just ask.)
bye-bye

Stumbled upon this post on Rebol.

So here's my contrib, if you want to parse Google Finance Historical Data, it's easy:

Rebol[
title: "Parse google finance csv file"
author: "http://reboltutorial.com/blog/parse-csvparse-csv/"
version: 1.0.0
]

symbol: ask "symbol: "
url: rejoin [http://www.google.com/finance/historical?q= symbol "&output=csv"]
stock-data: read/lines url
close-block: []
foreach element stock-data [
last-quote: parse/all element ","
append close-block pick last-quote 5
]
cum: 0
for i 2 21 1 [cum: cum + to-decimal close-block/:i]
average: cum / 20