9
99atlantic
If you wanted to use the get external data -> web query to download a
yahoo finance spreadsheet automatically, is there anyway to get it to
download and get it into proper column format automatically?
E.g., you want to have an automatic spreadsheet from
http://ichart.finance.yahoo.com/table.csv?s=MSFT&d=1&e=1&f=2050&g=d&a=1&b=1&c=1980
so you use that as the web query, except it downloads it as comma
deliminted, NON-COLUMIZED (i.e., just 1 big column). The only way I can
figure out how to get it into columns is to manually do it, but
certainly there's got to be some way to get it to automatically sort
upon download w/o you ahving to click through to tell it to.
yahoo finance spreadsheet automatically, is there anyway to get it to
download and get it into proper column format automatically?
E.g., you want to have an automatic spreadsheet from
http://ichart.finance.yahoo.com/table.csv?s=MSFT&d=1&e=1&f=2050&g=d&a=1&b=1&c=1980
so you use that as the web query, except it downloads it as comma
deliminted, NON-COLUMIZED (i.e., just 1 big column). The only way I can
figure out how to get it into columns is to manually do it, but
certainly there's got to be some way to get it to automatically sort
upon download w/o you ahving to click through to tell it to.