|11 months ago||3 days ago|
|MIT License||GNU General Public License v3.0 or later|
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.
VBA API call with nested JSON data
2 projects | reddit.com/r/vba | 10 Dec 2021
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?
1 project | reddit.com/r/vba | 9 Dec 2021
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?
1 project | reddit.com/r/vba | 19 Mar 2021
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
1 project | reddit.com/r/excel | 16 Feb 2021
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.
cryptofeed: NEW Data - star count:1320.0
1 project | reddit.com/r/algoprojects | 7 May 20221 project | reddit.com/r/algoprojects | 6 May 20221 project | reddit.com/r/algoprojects | 5 May 20221 project | reddit.com/r/algoprojects | 4 May 20221 project | reddit.com/r/algoprojects | 3 May 20221 project | reddit.com/r/algoprojects | 2 May 20221 project | reddit.com/r/algoprojects | 1 May 2022
Career advice after dropping out of CS degree
2 projects | reddit.com/r/cscareerquestionsEU | 6 May 2022
For example I would like to learn how to build packages such as these from scratch (https://github.com/bmoscon/cryptofeed , https://github.com/bmoscon/cryptostore ) that gather data from multiple crypto exchanges and be able to store/process the data efficiently
cryptofeed: NEW Data - star count:1079.0
1 project | reddit.com/r/algoprojects | 11 Dec 20211 project | reddit.com/r/algoprojects | 10 Dec 2021
What are some alternatives?
OctoBot - Cryptocurrency trading bot for TA, arbitrage and social trading with an advanced web interface
ib_insync - Python sync/async framework for Interactive Brokers API
influxdb-python - Python client for InfluxDB
coinbasepro-python - The unofficial Python client for the Coinbase Pro API
unicorn-binance-suite - The UNICORN Binance Suite is a Python Meta Package of unicorn-fy, unicorn-binance-local-depth-cache, unicorn-binance-rest-api, unicorn-binance-trailing-stop-loss and unicorn-binance-websocket-api.
btc-ticker-esp8266 - realtime bitcoin price on 7 segment display with arduino on esp8266
pump-and-dump-dataset - Additional material for paper: Pump and Dumps in the Bitcoin Era: Real Time Detection of Cryptocurrency Market Manipulations, ICCCN '20
binance-trader - 💰 Cryptocurrency Trading Bot for Binance (Experimental)
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel