Re: The FinancialData Function
- To: mathgroup at smc.vnet.net
- Subject: [mg89014] Re: The FinancialData Function
- From: Chris Degnen <degnen at cwgsy.net>
- Date: Fri, 23 May 2008 03:11:11 -0400 (EDT)
- References: <fsibce$64l$1@smc.vnet.net> <ft2arl$pf2$1@smc.vnet.net>
Jason Cawley wrote: > > On oil prices, that is one in the coming soon category, but I can > give you a solution that will work today, outside of FinancialData > proper. Soon there won't be a need for these sorts of lines, that > is sort of the idea. But for now, you can use - > > Daily spot oil prices from the Department of Energy, back to 1986 > > dailyDOEOil = {#[[1, 1 ;; 3]], N[#[[2]]]} & /@ DeleteCases[ > Import[ > "http://tonto.eia.doe.gov/dnav/pet/xls/PET_PRI_SPT_S1_D.xls", > "XLS"][[2, 4 ;;, 1 ;; 2]], {"", ""} | {_, ""}]; > That's great. Have you got one for gold? - for this kind of data: http://www.lbma.org.uk/statistics_historic.htm