InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now. Learn more →
Crypto_vba Alternatives
Similar projects and alternatives to crypto_vba
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
-
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
Discontinued Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
crypto-trading-bot
Cryptocurrency trading bot in javascript for Bitfinex, Bitmex, Binance, Bybit ... (public edition)
-
VBA-Expressions
A powerful library extending VBA with over 100 functions for math, stats, finance, and data manipulation. It supports matrix operations, and user-defined functions, enhancing automation and analysis within Microsoft Office and LibreOffice environments for data management, financial calculations, an more.
-
crypto_vba discussion
crypto_vba reviews and mentions
-
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.
-
A note from our sponsor - InfluxDB
www.influxdata.com | 19 May 2025
Stats
krijnsent/crypto_vba is an open source project licensed under MIT License which is an OSI approved license.
The primary programming language of crypto_vba is VBA.