by zenonhco | Jun 18, 2022 | Excel - API, Excel VBA, Excel-Python
Here’s an example where Excel VBA was integrated with OpenSSL and python that provided an auto login feature, in this case, into Betfair’s API to retrieve a session token. VBA auto generated the python code which was executed with the shell function. In this...
by zenonhco | Apr 22, 2022 | Excel - API, Excel VBA, Financial Modelling
I had the occasion to develop financial projections for a British based trading company. The challenge was to develop the financial projections to handle over a dozen currencies. The company’s business was to source commodities in a variety countries and import those...
by zenonhco | Apr 18, 2022 | Excel VBA
This blog is more about the trials of writing Excel apps, in particular when it comes to situations where the client asks for something had not been considered before. Early in my coding career, I needed to create a MouseRollOver event, which I presumed would be a...
Recent Comments