How to get historic Cryptocurrency Pricing into Excel with the new STOCKHISTORY function 

Thank you Paula for sharing this function....Brilliant application of knowledge...please keep sharing more functions like these to help us

Excellent! This was exactly what I have been looking for.. thanks!

Hi Paula.. looks great. Thanks for the intro to STOCKHISTORY.. very interesting. Thumbs up!!

Well Done. I highly appreciate your effort for making this video.

Great information. I had to reinstall Excel to fix the error I initially got after pasting the URL. Thanks.

Thanks! I learned a thing or two here. Very helpful

Absolutely brilliant!!! Thank you!

This is a great tutorial. Thank you so much for providing free high quality education! Excel Rich Datatypes are really a game changer in Excel. I was wondering, is there a way to avoid the spill all together and only get the closing price of one day in the past in one field, without extra date and header?

This was incredibly helpful! Thank you so much for the video.

BUT THIS IS NOT PROVIDING THE VOLUME, IF IT IS NOT NEEDED FOR YOU THEN THIS METHOD IS AWESOME. THANKS

Excellent.... This was exactly what I have been looking for.. Any way to extract hourly data for crypto? Thanks in Advance.

I did enjoy the video thank you

you are my teacher

Awesome.. Information.❤️❤️❤️ But how to get hours or minutes data

You deserve more

👍🏻👍🏻 awesome 😎

Thank you for this useful tutorial. I have a question. When I pulled BTC/USD OHLC data for 2023 using STOCKHISTORY function, Excel skipped a few days in a row here and there. Why could that be? And also, maybe I missed it but what source does Excel use for crypto prices?

Many thanks .... very interesting!

Exactly what I was looking for.

Worked Great

Thank you. Is there an option to fetch data for time intervals of hours ( more low level than daily ), for example ?

Hi Paula, this dosnt seem to be working for me when refrencing a cell but i cannot work out how to fix. Are you able to help?

This is wonderful. Can this be applied to trace for example the financial statement such as bank statement?

Hello, thank you for sharing this. Can we do this for BTC/USDT (Tether) instead of USD? How?

thank you...worked perfectly. I wish like you said i could pull in my other alt coin data like LINK and ADA.

How to add tommorrow data in this sheet.

Hi Good tutorial video, how to get previous 24 hours (every second change) data in excel for particular coin pls suggest

stockhistory formula at 4:50

really amazing

I am getting #value!. what was that inverted commas air quote? It is pulling the cards for me but not the data

Nice, but I don't understand, there is a way to have historic data divided per minute?

Can you pull this off in google sheets?

This is only for Excel 365. What about Excel 2021?

I cannot pull some Cryptocurrencies, how may I get them ? Example: AVAX crypto doesn't show up correctly. Instead it shows a traditional company info. How can I overcome this issue for this, and other cryptos ?

Thanks for the video. But can't find it. Is this not available on the MacOS Excel version?

Hello, does anyone know how to get a sheet with a minute interval?

how to pull data from website, and why some website didn't give access to excel to pull data

Can i track advance 10 weeks my coin? this is automatic update ?

Great potential - but most of my alt coins don't show up :(

Muito bom, obrigado!

Would this work in google sheets?

not every currency ticker is supported in excel

I need this data with no colon, no semi colon, and no $ Symbol

not available to other crypto.

this method working with Microsoft 365 only