Comments (6)
I think I figured it out.
Possibly these lines should be used:
Application.Calculation = xlManual
Application.Calculation = xlAutomatic
from crypto_vba.
Hi @scotchy33
thanks for your feedback. The functions like C_ARR_OHLCV work, but are not ideal. With that I mean: they pull in the right information, but they do refresh with every recalculation of the workbook (which is probably set to automatic). To counter that a bit, I've built in a bit of caching, so the information gets pulled in from CryptoCompare only maximum every minute, but that's still the cause for a massive slowdown of sheets and/or crashing of workbooks.
If you're using the functions from a macro you could indeed add those lines in your code (as well as Application.ScreenUpdating = False ), but for the function (in sheet) that wouldn't work. The only real solution I found is moving the "get info online" to either PowerQuery or a RTD, but none of them are on my priority list now.
Cheers,
Koen
from crypto_vba.
Hi @krijnsent,
Thank-you for the response. When going through some of the API information on Crypto websites, it says that you need an enterprise/pro (Paid version) API key for historical prices. However, your macro for historical prices works, even without an API key. Is there a limit on how often you can send requests to CryptoCompare and/or CoinMarketCap?
Thank-you,
Scott
from crypto_vba.
https://min-api.cryptocompare.com/pricing -> 250k lifetime calls free. So say you want to use them up in the coming 5 years, that would be 250k/365/5=137 calls/day. If you know of any other good open APIs, do let me know, for now cryptocompare has been the only one I would recommend.
from crypto_vba.
How do they track your calls if you do not enter an API key? I don't believe your macro is using one.
I can see them tracking an IP address for daily use, but to track an IP address until 250k calls have been used seems impractical.
from crypto_vba.
No clue, not my problem :-). They hopefully have something on their side, from my side I only use their API. I expect some kind of error message when I go over my limit. I am using it moderately, guess max 10 calls/day.
from crypto_vba.
Related Issues (20)
- Deribit, FTX HOT 1
- Coinbase: View Transactions HOT 4
- Trojan:Script/Oneeva.A!ml Windows Defender HOT 3
- CoinbasePro all fills HOT 1
- Can you add Uphold? HOT 1
- Definition of some functions HOT 4
- Error in Sub TestBitVavo() HOT 2
- How to Get Binance Withdraw History? HOT 3
- Add Celsius Wallet
- Place Buy/Sell order? HOT 7
- Woo x HOT 1
- Binance and OKEx errors. HOT 1
- coinbase error HOT 1
- Virus included in the download HOT 1
- how to add new crypto currencies (coinbase) HOT 1
- Cannot get Binance and Coinbase Pro to work in example sheet HOT 2
- can't download HOT 4
- Kucoin Api V2 HOT 1
- Kraken Api, place order HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from crypto_vba.