crypto_vba
An Excel/VBA project to communicate with various cryptocurrency exchanges APIs (by krijnsent)
VBA-JSON
JSON conversion and parsing for VBA (by VBA-tools)
Our great sponsors
crypto_vba | VBA-JSON | |
---|---|---|
4 | 9 | |
143 | 1,211 | |
- | 2.0% | |
0.6 | 0.0 | |
11 months ago | 5 months ago | |
VBA | Visual Basic | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
crypto_vba
Posts with mentions or reviews of crypto_vba.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-12-10.
-
VBA API call with nested JSON data
It basically uses the Dictionary object to create variables (e.g. with a dictionary in a dictionary) and after that using that library to transform it into a string. I'm using it in my project here: https://github.com/krijnsent/crypto_vba/blob/master/ModExchKucoin.bas
-
Where should I store API Keys?
I agree with u/sslinky84 that there is no safe place in VBA. The main question is: what's the purpose of an API key in this case? From your description you are not linking an API-key to a single user, but have "one key to rule them all". So you probably want to prevent someone from grabbing your end-point and spamming it? In that case you're perfectly fine in creating one API-string in VBA and checking that on the server: it blocks the person who is opening a browser to fiddle with your end-point, but it does give you some security. The people who can get through are the ones that manage to crack open your VBA (assuming you have a password on the VBA). To make their life a bit harder you could instead of a "fixed string" as API key go for some kind of hash, as u/archn suggests. E.g.: take the rest of the post message that e.g. also includes a mandatory timestamp, make a simple hash of that (might even include a "fixed key", see e.g. https://github.com/krijnsent/crypto_vba/blob/master/ModHash.bas for some code).
-
Self made Excel/VBA triggers virus scan - what to do?
I've built an open source VBA-Excel library to communicate with cryptocurrency exchanges ( https://github.com/krijnsent/crypto_vba ) and have my code available as .bas and in an .xlsm file. A couple of days ago someone posted an issue that my xlsm file triggered a Windows defender alert. At my pc this doesn't happen, the AVG virus scanner also won't show anything.
-
How to import price actions with API from CoinGecko
I am mainly using Cryptocompare, but if you want to use CoinGecko, check out my code, it has the basics: https://github.com/krijnsent/crypto_vba/ It has most of the essentials: connecting Excel to web, handling Json and some API examples.
VBA-JSON
Posts with mentions or reviews of VBA-JSON.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-12-10.
-
Is there any way to format and stylise an excel file from an json file?
Have you tried the VBA-JSON library? That includes a method that will format your JSON files with indenting, etc. As for styling the output, that again can be done with VBA. I did something just like this a few years ago, I can look for the code if you're interested.
-
Visual Basic 6 + JSON
I've used this https://github.com/VBA-tools/VBA-JSON in the past with VBA which may work for your case and it had issues if it was very complicated json but for things like web services worked fine for me
-
API (JSON) call into MsAccess
I've done something similar using a HTTP request and a JSON converter module.
-
Show Data of Record in single cell (JSON Import)
If you're comfortable with VBA, you might want to check out VBA-JSON.
-
VBA API call with nested JSON data
The terms you could search for are "VBA" & "JSON" ;-). My first hit is: https://github.com/VBA-tools/VBA-JSON -> that has even an example (scroll down) of a 2 level JSON.
-
[EXCEL] Is it possible to save and repopulate values in an UserForm after a while?
Here's the great JsonConverter module for parsing JSON data into data structures. The hardest part about using this, is figuring out how to access your data once you've passed the JSON data to the module. Depending on the complexity of the JSON data, it can be pretty unintuitive in how to export or access the parsed data.
- What is the best way to distribute a VBA API and the JSON parser I'm using?
-
VBA API to get data
jsonConverter : VBA-tools/VBA-JSON: JSON conversion and parsing for VBA (github.com)
-
VBA to call a value from API and populate in sheet.
Below VBA should help. You need to add a reference to the MS Scripting Runtime in VBE > Tools > References. You also need to import the JSON Converter module by Tim Hall.
What are some alternatives?
When comparing crypto_vba and VBA-JSON you can also consider the following projects:
crypto-trading-bot - Cryptocurrency trading bot in javascript for Bitfinex, Bitmex, Binance, FTX, Bybit ... (public edition)
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
coinbasepro-python - The unofficial Python client for the Coinbase Pro API
cryptofeed - Cryptocurrency Exchange Websocket Data Feed Handler
ccxws - WebSocket client for 38 cryptocurrency exchanges