Is there a way to update a spreadsheet with current stock prices?

[pmasse13]

Hi Kirk,
Is there a way to update a spreadsheet with current stock prices?
I currently use Google sheets to import them into my spreadsheets.

I use to use yahoo and before that Microsoft. They both stopped working at some point.
Just wondering if there's something better that google sheets ?

Thank you again.
Philip Masse

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 365, see if this is any use: Excel data types: Stocks and geography

 

[pmasse13]

Sorry.... I am using Version 97-2003

 

[alansidman]

See if this workaround suits your needs. Also, please update your profile to reflect the version you are using as it will impact any request you have in the future.

Excel: stock prices from Google Finance

Here's another method of getting stock prices into Excel. It's part of a series: introduction and using MSN Money in Excel. This time we'll use the impr

office-watch.com