Downloading yahoo EOD prices

Discussion in 'Trading Software' started by abducens, Aug 20, 2004.

  1. fielman

    fielman

    Very handy tool!

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

    Thanks
     
    #21     Aug 10, 2007
  2. rebtut

    rebtut

    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
     
    #22     Sep 2, 2009