Forum Discussion
Can I use Excel to get finance information like Google Sheet?
I use Google sheet to fetch Google Finance data directly for stocks. Is there a way to use MS Excel for the same? I mean can I fetch information from bing finance or something? I have to embed that...
You should be able to. If you enter some stock symbols into a bunch of cells, you can then click Data and select the Stocks datatype. If there is ambiguity, a taskpane will pop up for you to select the correct one(s).
After the cell has been turned into a stock data-type a small icon appears which allows adding columns with information about the stock:
Selecting any item in the drop-down will add a column alongside the data.