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...
by zenonhco | Apr 1, 2022 | Scripts
As always, when you need something you can’t find it. I needed to restore my windows system, but alas, no CD and my Certificate of Authentication was barely legible. Saved by a colleague of mine. She sent me a VB script that I used to retrieve my 25-digit code from my...
by zenonhco | Jul 24, 2019 | Other
EPL Fantasy players please consider joining my H2H leagues for this upcoming season. EPL H2H Fantasy Codes 2019/20: rs2b1i, dvg7vt, 0baure
Recent Comments