Тёмный

Import Multiple Stock Tickers Into Excel Using Power Query 

HowtoExcel.net
Подписаться 15 тыс.
Просмотров 6 тыс.
50% 1

Наука

Опубликовано:

 

8 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@mlo6459
@mlo6459 2 месяца назад
Thanks for the video. Is there a way to connect a query to a website (eg Yahoo) to get 'today's' price?
@h2e
@h2e 2 месяца назад
I would suggest using Google Sheets to track current stock prices. It's much easier to accomplish this. Refer to this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4tsJZeB8AoI.html
@mlo6459
@mlo6459 2 месяца назад
Thanks. I discovered Excel's Data\Stocks function which is giving me exactly what I need.
@whitedancer5866
@whitedancer5866 2 года назад
How about those that can't be downloaded like Financials tab?
@aubreysmith5169
@aubreysmith5169 2 года назад
Let's say I've got a portfolio of, say, 60 stocks, and I want to track certain aspects of their daily rate of change; is there a way to get excel to connect with yahoo finance and download all 60 tickers together; rather than taking an hr to download them one at a time?
@h2e
@h2e 2 года назад
I hear you. I track hundreds of stocks and the best way by far is using Google Sheets. I did a video on this in the past showing how you can do that and import in Excel if you wanted to. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H1jH74kAp6M.html
@MrEstebanEscudero
@MrEstebanEscudero Год назад
great video! New subscriber
@judeflinson243
@judeflinson243 7 месяцев назад
I'm unable to see the download button.
@h2e
@h2e 7 месяцев назад
Should be on the historical data tab. You may want to try a different browser if you don't see it.
Далее
How to Analyze an Income Statement in Excel
11:47
Самое неинтересное видео
00:32
Просмотров 1,2 млн
Try This Instead of the XLOOKUP
10:06
Просмотров 55 тыс.
10x your productivity with these AI tools in Excel 😲
18:42