I came across a useful technique recently to get Yahoo Market Data in Python … which still works!! In the past I have tried a number of methods and techniques to get market data. Often the API or free data service would be discontinued and the method stops working. However, obtaining Yahoo market data with…
Read more
Variables can be a little tricky to get your head around at first. They are an important concept and a good understanding of them leads to bug-free, easy to read and efficient code. The length of this post reflects the importance of declaring and using variables sensibly in VBA. We will touch on the topic…
Read more
One of the easiest ways to improve your VBA code is to include Option Explicit as the first line of each module within a VBA Project. Using Option Explicit forces all variables to be declared in some manner before they can be used. This might not sound important now since most of your code will…
Read more
This is a little gem that I found awhile back. Mathematica/Wolfram have a project whereby people can author a CDF document (computable document format). Once created they can be published online for free. The set of online CDFs was originally named the Mathematica Demonstrations Project (hence the title). However, it now looks to have been…
Read more
How to Save an Excel Worksheet as CSV file using VBA.
