ECPTextStream
crypto_vba
Our great sponsors
ECPTextStream | crypto_vba | |
---|---|---|
5 | 4 | |
11 | 154 | |
- | - | |
0.0 | 0.0 | |
about 1 year ago | over 1 year ago | |
VBA | VBA | |
GNU General Public License v3.0 only | MIT License |
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.
ECPTextStream
-
Meet a library member: CSVTextStream, the king of performance.
The table below shows the overall performance for the read operations, you can download the test files from here. The test machine is running Win 10 Pro 64-bit, Intel® Core™ i7-4500U CPU N2600 @1.80 GHz - 2.40 GHz, 8 GB RAM.
-
Removing all blank lines at the end of a text file
This is a perfect use case for ECPTextStream. Create a loop for read the source text file and write the result file. Inside the file loop, manage to handle the last chunk of information and remove the last char until a line break is found.
-
[Access] Any alternatives to Scripting.TextStream that eat up less memory?
Maybe the ECPTextStream class module can help you. This library is faster than the scripting method when dealing with text files and can manage files up to 2GB without any problem. See the benchmarks here.
-
VBA CSV Interface v3 Pre-release
Parse CSV/TSV through streams with the ECPTextStream class module.
-
What have you been working on? (Week of January 29, 2021)
New versión of the VBA-CSV Interface class. This will integrate the ECPTextStream class module in order to reduce memory overloads when retrieving few records from a CSV file.
crypto_vba
-
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.
What are some alternatives?
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
crypto-trading-bot - Cryptocurrency trading bot in javascript for Bitfinex, Bitmex, Binance, Bybit ... (public edition)
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
ccxws - WebSocket client for 38 cryptocurrency exchanges
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
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).
VBA-JSON - JSON conversion and parsing for VBA
coinbasepro-python - The unofficial Python client for the Coinbase Pro API
cryptofeed - Cryptocurrency Exchange Websocket Data Feed Handler
VBAUnicodeTools - Tools for working with Unicode in the VB Editor