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

#excel #bitcoin #eth #cryptocurrency #stockhistory
In this video, you will learn how to use Excel's new function STOCHISTORY to get historic cryptocurrency pricing. This is a great alternative to Coinmarketcaps premium API. STOCKHISTORY is coming to Excel 365 soon
Other videos of interest
How to create awesome stock charts in Excel
• How to create awesome ...
Master the use of RICH DATA TYPES in Excel
theexcelclub.com/rich-data-ty...
Find out more about our Learn and Earn Activities
theexcelclub.com/learn-and-ea...
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel - Playlist

[@bengee69]

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

[@muralk3153]

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

[@AP-vv5ci]

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

[@BIMoji1]

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

[@dustyarcher]

Absolutely brilliant!!! Thank you!

[@babaganushsky]

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

[@johnbellavich3063]

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

[@negociosonline40]

Muito bom, obrigado!

[@OmikronPsy]

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?

[@radowane101]

I did enjoy the video thank you

[@wayneedmondson1065]

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

[@PaulaWeb3andCrypto]

Thanks Wayne

[@PaulaWeb3andCrypto]

I'm glad you liked the video Wayne

[@michelerampazzo]

Many thanks .... very interesting!

[@PaulaWeb3andCrypto]

You are welcome

[@frankfioretti3945]

Worked Great

[@Zaher.Taleb.mechanical.design]

really amazing

[@redsalinga]

You deserve more

[@farooqishaq6974]

Exactly what I was looking for.

[@PaulaWeb3andCrypto]

awesome

[@marakochina]

you are my teacher

[@rvamerongen]

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

[@ExcelExciting]

👍🏻👍🏻 awesome 😎

[@PaulaWeb3andCrypto]

Thank you

[@Zues64]

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

[@PaulaWeb3andCrypto]

Glad it helped. I think you might like our new tracker, you can get the other coins in it. ruclips.net/video/3Zg8ufnFQHM/видео.html

[@ZenZoneLiving]

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

[@gennadysudat9533]

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?

[@pepecognito]

stockhistory formula at 4:50

[@andreyrapoport1126]

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

[@anis6538]

if you found how we can do it explain me !!

[@lewisbailey5724]

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?

[@karthiksha6723]

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

[@mslulcek]

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

[@deepaktopno126]

How to add tommorrow data in this sheet.

[@km1098]

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

[@harshanatha]

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

[@davincicode1238]

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

[@SolomonKinyanjui_sk]

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

[@PaulaWeb3andCrypto]

There is a new Microsoft money that has been released in the US that can do something like that. I don't have access yet but when I do, I will make a video. STICKHISTORY is different

[@SolomonKinyanjui_sk]

@@PaulaWeb3andCrypto Thank you. I'm waiting to see the new function.

[@lnoir493]

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

[@magicdoty]

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

[@T-equalizer]

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

[@simonethetretelayer5885]

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

[@snaq1990]

Would this work in google sheets?

[@andre_crespo]

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

[@mikeangelo2290]

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 ?

[@johnfrancispederson]

Can you pull this off in google sheets?

[@roxnroll8050]

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

[@techhunt4922]

not every currency ticker is supported in excel

[@henrylmijaresm3871]

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

[@krovikantv535]

not available to other crypto.

[@WinCento99]

this method working with Microsoft 365 only