|
Iowa | I worked on this a little with Excel. It is much easier than I thought it would be to get the commodity prices from a web page to show up in Excel and automatically update or manually update as desired. Just click on "from web" under the data tab to get started. The problem is that some commodities like corn and soybeans are expressed in fractions of a penny (3.65'2 instead of 3.6525). Excel reads those fraction type formats as text rather than a number, so I can't use those cells directly in equations.
I asked this question on market talk and got no response, so I'll try asking here: Do you know of any web sites with corn and soybean futures displayed in decimal form rather than the fraction format? Or is there an easy way (without writing a macro) to convert the prices expressed in fraction format to a decimal format? | |
|
Commodity prices in google sheets
