From: 7stud -- <bbxx789_05ss@...>
Date: 2009-02-17T05:34:35+09:00
Subject: Re: Parsing CSV file into a database

Bosko Ivanisevic wrote:
> On Feb 16, 5:39�pm, Nick Hoyle <nih...@tiscali.co.uk> wrote:
>> >> sample code or examples that you could possible provide me?
>> > � �end
>>
>> > Give it a shot and come back with specific questions when you get stuck.
>>
>> > James Edward Gray II
>>
>> --
>> Posted viahttp://www.ruby-forum.com/.
> 
> Here is a sample for downloading historical data from Yahoo:
> 
> def get_historical_data(symbol, startDateString, endDateString)
>   startDate = Date.parse(startDateString)
>   endDate = Date.parse(endDateString)
>   query = "/table.csv?s=#{symbol}&g=d" +
>           "&a=#{startDate.month-1}&b=#{startDate.mday}&c=#
> {startDate.year}" +
>           "&d=#{endDate.month-1}&e=#{endDate.mday}&f=#
> {endDate.year.to_s}"
>   Net::HTTP.start("itable.finance.yahoo.com", 80) { |http|
>     res = http.get(query)
>     res.body
>   }
> end


require 'date'
require 'net/http'

def get_historical_data(symbol, startDateString, endDateString)
  startDate = Date.parse(startDateString)
  endDate = Date.parse(endDateString)
  query = "/table.csv?s=#{symbol}&g=d" +
          "&a=#{startDate.month-1}&b=#{startDate.mday}&c=#
{startDate.year}" +
          "&d=#{endDate.month-1}&e=#{endDate.mday}&f=#
{endDate.year.to_s}"
  Net::HTTP.start("itable.finance.yahoo.com", 80) { |http|
    res = http.get(query)
    res.body
  }
end

p get_historical_data("AAPL", "12/28/2008", "1/7/2009")

--output:--
/usr/lib/ruby/1.8/net/http.rb:1556:in `read_status_line': wrong status 
line: "Date,Open,High,Low,Close,Volume,Adj Close" (Net::HTTPBadResponse)
        from /usr/lib/ruby/1.8/net/http.rb:1538:in `read_new'
        from /usr/lib/ruby/1.8/net/http.rb:833:in `request'
        from /usr/lib/ruby/1.8/net/http.rb:615:in `get'
        from r1test.rb:13:in `get_historical_data'
        from r1test.rb:12:in `start'
        from /usr/lib/ruby/1.8/net/http.rb:324:in `start'
        from r1test.rb:12:in `get_historical_data'
        from r1test.rb:18

-- 
Posted via http://www.ruby-forum.com/.