csv - YQL - wrong query -
can tell me whats wrong yql statement:
select symbol, earnings_per_share, dividend_yield, week_low, week_high, last_trade_date, open, low, high, volume, last_trade csv url="http://download.finance.yahoo.com/d/quotes.csv?s=yhoo,goog&f=seyjkd1oghvl1&e=.csv" , columns="symbol,earnings_per_share,dividend_yield,last_trade_date,week_low,week_high,open,low,high,volume,last_trade" in(select * yahoo.finance.historicaldata symbol = "yhoo" , startdate = "2009-09-11" , enddate = "2010-03-10")
i want properties: http://www.electronics4design.com/wp-content/uploads/2015/07/pricetable.jpg
what trying ? if need yhoo data, try this
select symbol, earnings_per_share, dividend_yield, week_low, week_high, last_trade_date, open, low, high, volume, last_trade csv url="http://download.finance.yahoo.com/d/quotes.csv?s=yhoo&f=seyjkd1oghvl1&e=.csv" , columns="symbol,earnings_per_share,dividend_yield,last_trade_date,week_low,week_high,open,low,high,volume,last_trade"
i removed goog url=...
Comments
Post a Comment