In short, I have my data stored in SQL and load it into Excel which is used as a front end for final analysis. Basically, a lot of stuff is computed in C#, stored in SQL and then loaded into Excel. I'm having minor issues - particularly since I'm updating intraday (either automatically or by discretion) - but so far I'm living with it. Issues being speed/stability when loading data. Is Access both a database and a front-end?
Well, it applies to trading and time-critical applications. For research it's fine but I still consider it more limited. I'm running fully automated trading using Python.
I need to go to Coursera and sign up for a course in Python programming (3 months), then spend another 6 months learning how to. Maybe I can find a VBA macro I can plug in and run?
There's plenty of Python examples online. Why would you need Coursera? But obviously copy-paste is faster than actually learning something. This is true for anything.
Hard to learn without someone holding my hands. Took me over a year to learn VBA, hard to give it up yet. But thank you for your suggestions.
Maybe you can point me to where to get help: 1. I use a MacBook Pro. Where in my Mac can I find Python programming language? 2. I have a 2011 version of Excel, can Python work with my data in Excel? Thanks.
It only takes a web search: Python for OSX There are Excel libraries for Python that work well but I haven't used them. Why do you need to use Excel at all?
https://www.youtube.com/watch?v=Mu1I89BeKxM https://www.youtube.com/watch?v=yE9v9rt6ziw https://www.youtube.com/watch?v=vaysJAMDaZw https://www.youtube.com/watch?v=3cZsjOclmoM There ya go. About 40 hours of handholding. If you use Linux you can save them to your HD using youtube-dl. Amazon has those "book" thingies, too. Seriously, you can learn just about anything between wikipedia, google, youtube, reddit, quora, and those book things.
Is that free? I need to use excel because that is all I know and all my data/formula/backtest are stored in excel.