Tutorial - Using Excels new STOCKHISTORY function to get historic Cryptocurrency pricing into Excel

avatar

Two weeks back I announced an upcoming function in Excel that will allow you to get historic cryptocurrency pricing into Excel, The preview proved popular and I am delighted to share with you today a full tutorial on using the new STOCKHISTORY function in Excel to get historic pricing information into your spreadsheets without the need to connect to an API.

When Coinmarketcap changed its API, much of the data available became part of a premium service. This was a blow to many, like myself. However, the introduction of this new Excel function will fill the gap for many. At the moment, historic information is available for Bitcoin, Bitcoin Cash, Litecion, Etherum, Bitcoin Cash and XRP.

In addition to cryptocurrency pricing, STOCKHISTORY also works with Stock, bonds, Equities and FX.

I hope that you enjoy the tutorial and I hope that you will like and share the video. I can't wait to hear your feedback, please do leave a comment below and let me know what you think of the new STOCKHISTORY function in Excel

Posted Using LeoFinance



0
0
0.000
7 comments
avatar

Thanks for introducing amazing excel function with the help of nice tutorial. We are looking for people like you in our platform.
Your post has been submitted to be curated with @gitplait community account because this is the kind of publications we like to see in our community.

Join our Community on Hive and Chat with us on Discord.

[Gitplait-Team]

0
0
0.000
avatar

Maybe you can look into the API of Coingecko and I believe it is free. My backdrop green is coming, I will be able to do videos like yours. ;)

0
0
0.000
avatar

I haven't looked at the coingeko app at all. Thanks for the info

0
0
0.000
avatar

My pleasure, a great alternative to CoinMarketCap.

0
0
0.000
avatar
(Edited)

This is great!
Thanks for the update.

p.s. where to get the info which crypto prices are supported?
p.s.s :) Still not available for everyone :)

Note: This is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Microsoft 365 subscribers

0
0
0.000
avatar

I can't find a list of supported cryptos. Trail and error right now. Its seems to be only a handful. Maybe its only ones that are supported in futures on the markets.

Yes STOCKHISTORY is still not available to everyone, but if you are on 365 you can switch to insiders/beta from the account settings.

0
0
0.000