Can anybody tell a me how I can load a large vertical list into the margin of a spreadsheet?
e.g, I want to copy a list of stocks from notepad (aligned vertically) to Google spreadsheet with each word in its own cell vertically down the left margin of a Google spreadsheet;
Also if I want to get the volume of all of these stocks in column A via a feed from Yahoo finance BUT wanted to do it in one line of code rather than add it stock by stock how can I do that ?
The inputs I have are price, price % change, volume, volume ave. I can do all of those individually but I'd like to be able to add the stocks to it in bulk quickly.
And that should be updated every 20 minutes right?