crypto_vba VS VBA-Expressions

Compare crypto_vba vs VBA-Expressions and see what are their differences.

VBA-Expressions

A powerful string expression evaluator for VBA and LO Basic, which puts more than 100 mathematical, statistical, financial, date-time, logic and text manipulation functions at the user's fingertips. (by ws-garcia)
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
crypto_vba VBA-Expressions
4 5
154 18
- -
0.0 7.0
over 1 year ago 5 days 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.

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
    2 projects | /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 | /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 | /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 | /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.

VBA-Expressions

Posts with mentions or reviews of VBA-Expressions. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-03-06.
  • Evaluate piecewise functions in VBA
    1 project | /r/vba | 17 Oct 2022
    So, if a Dominican needs to calculate the taxes that will be charged to them monthly, they should take pencil and paper, compute the annual amount of income and apply the corresponding formula, or they can use the following code in conjunction with VBA Expressions and get their result in a simple way.
  • Solving systems of linear equations with VBA
    1 project | /r/vba | 15 Oct 2022
    Systems of linear equations have been taught since high school, they are of utmost importance in mathematics. Although Excel is possible to solve, manually, equations using matrix inverse and matrix multiplication. Today we will show you a practical way to solve such problems using VBA Expressions.
  • Expression evaluator for VBA
    1 project | /r/github | 10 Oct 2022
    Here is a direct GitHub link to VBA Expressions Best regards!
  • Advanced CSV filtering through VBA
    2 projects | /r/vba | 6 Mar 2022
    After this publication, which details the reason why VBA Expressions turned out to be the most feasible option to solve the problem of integrating an expression evaluator with CSV Interface, it is time to address the process of integrating the evaluation capabilities and the ease with which this goal was achieved.
  • Evaluating expressions from strings in VBA
    4 projects | /r/vba | 20 Feb 2022
    After a long search for something similar to the above, I decided to experiment and test the veracity of a warning that read: "... rather, it evaluates the infix expression directly. This approach is slightly more complicated than the traditional one". Then, I chose to develop an evaluator with its own grammar and a different approach to handle mathematical expressions. The solution I came up with is so called VBA Expressions. With VBA Expressions we can evaluate a variety of mathematical expressions, being able to work with arrays defined by text strings as in Java. A notorious feature is the ability to work with variables (Pi.e * 5.2Pie.1 + 3.1Pie), constants (3pi+ln(2e)), floating point numbers ((1.434E3+1000)*2/3.235E-5) and Boolean values (x>0 & Sqr(x-Ln(2))>=3 | tan(x)<0).

What are some alternatives?

When comparing crypto_vba and VBA-Expressions you can also consider the following projects:

crypto-trading-bot - Cryptocurrency trading bot in javascript for Bitfinex, Bitmex, Binance, Bybit ... (public edition)

VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.

ccxws - WebSocket client for 38 cryptocurrency exchanges

stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.

VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA

Code-Finds-Determinant-of-a-Array-in-C

QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel

Tiger - C++ Matrix -- High performance and accurate (e.g. edge cases) matrix math library with expression template arithmetic operators

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