Could I utilize Python for SMF?
I have done some work with calling python modules from within Excel. My issue has been that I have been unable to write to the currently open workbook.
For myself, I use python to get market data and data from IB (Interactive Brokers) and I write some of that data to Excel files. It is quite easy to for python to read, create and modify data in Excel files.
There are add-ins to do this like PyXLL or XLWings, but they are somewhat commercial products. I say somewhat since PyXLL has a 30 day demo and XLWings has an open source version that is free if somewhat feature limited. In the spirit of Randy's SMF Add-In, I am working on a open source and free way of implementing python solutions for Stock Market Functions.
Some ideas that I am testing are creating some python utilities to do some of the work of the SMF Add-In that could work alongside of it. Use it to get slow or hard to get data, write it to CSV or XLSX files that can be linked to a Stock Dashboard or other Workbook that can utilize that data.
No comments:
Post a Comment