Sorry for kicking the hornets nest, but I really am enjoying this enthusiasm. From what I have read, there are also ways to utilize excel with python as well (using Py instead of VBA I think?). Not to force the issue with Python (although I think it's a very powerful language), but maybe this discussion will lead to using the best tools to accomplish what everyone is interested in. I use Slack and am involved in a project developing an algorithmic trading system using a tool called Zorro (programming with C Lite). In that project, we are able to share code, articles, etc. using Slack without any problems. I run Slack both on my Mac & Windows desktops as well as on my iPhone where I can get notified of discussions & messages. As far as code sharing on Slack, different channels can be set up so that one channel becomes a repository for code ideas (or maybe one for excel & one for Python) and the other channel is a discussion channel. But the code can be shared directly in the channel and it's all searchable as well. All of this however, can be done here in the Aeromir forums as well, but is a bit difficult to track on the iPhone.
All that to say that I am open to whatever you all decide as I am really interested to learn and improve my efficiencies in managing my trades ... hopefully that will also translate into more and consistent profits with better decision making. One thing I have learned is that putting processes into an algorithmic framework helps to solidify the process and also identify shortcomings that can be tweaked in the process. I use the term algorithm in this sense not as an app or automation/robot, but more of a definition of a trading process and decision making framework from start to finish. I also trade FX which requires a very rigid process, especially in terms of risk & money management. Options however, I have found at times to be a bit more nuanced, especially when trying to get filled on orders, especially 4 legged condors that need to be split in two separate orders and trying to identify appropriate stops, conditional orders, etc. is definitely a moving target with options because there are so many factors you can key off of such as underlying price, the greeks, T+ projections, etc. This is why I have expressed my desire to have a dashboard type decision frame work that I can use for each trade based on my set of rules (or at least rules that others have defined as best). I envision being able to enter a ticker and the associated strikes and dates that bring in the data to a model for a specific trade I want to put on or have put on, and see at a glance all the relevent metrics such as breakeven, and even an associated price if I wanted to close or open the trade with 4 legs or 2 legs, additional strategies that can be used, with subtotals and grand totals for each component and the entire trade. At this point, I am not really needing to analyze a trade such what the greeks look like or stepping out for future projections, although that could be something to consider down the line. I am not sure how difficult that would be.
Again, sorry for the brain dump.
So any suggestions about how/where to start? Probably need to define what a first end state might look like and work towards that goal. I am happy to bug test, provide ideas, help code, run errands ... whatever is needed. ;-)
Thanks,
Steve
All that to say that I am open to whatever you all decide as I am really interested to learn and improve my efficiencies in managing my trades ... hopefully that will also translate into more and consistent profits with better decision making. One thing I have learned is that putting processes into an algorithmic framework helps to solidify the process and also identify shortcomings that can be tweaked in the process. I use the term algorithm in this sense not as an app or automation/robot, but more of a definition of a trading process and decision making framework from start to finish. I also trade FX which requires a very rigid process, especially in terms of risk & money management. Options however, I have found at times to be a bit more nuanced, especially when trying to get filled on orders, especially 4 legged condors that need to be split in two separate orders and trying to identify appropriate stops, conditional orders, etc. is definitely a moving target with options because there are so many factors you can key off of such as underlying price, the greeks, T+ projections, etc. This is why I have expressed my desire to have a dashboard type decision frame work that I can use for each trade based on my set of rules (or at least rules that others have defined as best). I envision being able to enter a ticker and the associated strikes and dates that bring in the data to a model for a specific trade I want to put on or have put on, and see at a glance all the relevent metrics such as breakeven, and even an associated price if I wanted to close or open the trade with 4 legs or 2 legs, additional strategies that can be used, with subtotals and grand totals for each component and the entire trade. At this point, I am not really needing to analyze a trade such what the greeks look like or stepping out for future projections, although that could be something to consider down the line. I am not sure how difficult that would be.
Again, sorry for the brain dump.
So any suggestions about how/where to start? Probably need to define what a first end state might look like and work towards that goal. I am happy to bug test, provide ideas, help code, run errands ... whatever is needed. ;-)
Thanks,
Steve