crypto_vba
An Excel/VBA project to communicate with various cryptocurrency exchanges APIs (by krijnsent)
VBA-JSON-parser
Backus-Naur Form JSON Parser based on RegEx for VBA (by omegastripes)
| crypto_vba | VBA-JSON-parser | |
|---|---|---|
| 4 | 2 | |
| 163 | 114 | |
| 0.0% | 0.0% | |
| 0.0 | 0.9 | |
| over 2 years ago | 3 months ago | |
| VBA | VBA | |
| MIT License | GNU General Public License v3.0 only |
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-parser
Posts with mentions or reviews of VBA-JSON-parser.
We have used some of these posts to build our list of alternatives
and similar projects.
-
Accounting software glitch leads to using old/incorrect fx rates in invoices
Downloaded and imported VBA-JSON-parser
-
Extract data from a blob of text
Have you tried VBA JSON Parser?
What are some alternatives?
When comparing crypto_vba and VBA-JSON-parser you can also consider the following projects:
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).
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
cryptofeed - Cryptocurrency Exchange Websocket Data Feed Handler
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary