How to fetch real time Stock Prices in Excel using Stock Quote

preview_player
Показать описание
Microsoft Excel makes it really simple to retrieve stock market prices. Its Stock data type is connected to an online data source that allows you to access rich, interesting information that you can work with and refresh.

The way to do it is like this:

1] Create a table

2] Enter a ticker symbol

3] Let Excel find the match for your entries

4] Add a column to extract more information

5] Space the entries in the table

Рекомендации по теме
Комментарии
Автор

Hei, I cant fint the "stocks" option. Its not there. I have nothing between "connections" and "sort filter". What do I do ?

zitoboy
Автор

The #### may be because the cell is too small as well.

k-enespanol