I have a suggestion for the trade log spreadsheet
I was thinking maybe you want to add a front end to it for other traders that are not trading 0 DTE trades but still want a trade log spreadsheet
There were a few members not long ago who were asking about a trade log to track their option trades
In particular I was thinking about the Boxcar Tools Ver 0.92 spreadsheet from around Feb 23 that was one of the last one before it was started to be changed to the day trading spreadsheet Not sure if you still have it or if you want to recreate it
I particularly liked that one and I am still using it I think it's very useful to anyone who has TOS to take advantage of the RTD functions to pull in the data
It had a monitor tab and I made copies of this tab one for each brokerage account that is where I enter the opra code and keep track of the p/l
It also had a dashboard I also modified it to pull in the data from all the brokerage tabs than at the end of the day I transfer the data from the dashboard using a little macro to another spreadsheet that way it locks in the historical data and keep track of the daily p/l moves and I also take a screenshot of the analyze tab and place it in a folder and from there I use a hyperlink to each trade that way I can click on any hyperlink and show a screenshot of the analyze tab at any time in the trade EOD
Later on I added a table to the spreadsheet that has the monitor tab and when I close a trade I transfer the data to the table which looks somewhat similar to your trade log spreadsheet except I don't have daily trades so for someone who makes 0 dte trades your spreadsheet would be simple enough to use but for those who make longer dte trades and have some adjustments I thought it might be better to use some RTD to keep track of each leg rather then just the total p/l for the trade
I was thinking maybe you want to add a front end to it for other traders that are not trading 0 DTE trades but still want a trade log spreadsheet
There were a few members not long ago who were asking about a trade log to track their option trades
In particular I was thinking about the Boxcar Tools Ver 0.92 spreadsheet from around Feb 23 that was one of the last one before it was started to be changed to the day trading spreadsheet Not sure if you still have it or if you want to recreate it
I particularly liked that one and I am still using it I think it's very useful to anyone who has TOS to take advantage of the RTD functions to pull in the data
It had a monitor tab and I made copies of this tab one for each brokerage account that is where I enter the opra code and keep track of the p/l
It also had a dashboard I also modified it to pull in the data from all the brokerage tabs than at the end of the day I transfer the data from the dashboard using a little macro to another spreadsheet that way it locks in the historical data and keep track of the daily p/l moves and I also take a screenshot of the analyze tab and place it in a folder and from there I use a hyperlink to each trade that way I can click on any hyperlink and show a screenshot of the analyze tab at any time in the trade EOD
Later on I added a table to the spreadsheet that has the monitor tab and when I close a trade I transfer the data to the table which looks somewhat similar to your trade log spreadsheet except I don't have daily trades so for someone who makes 0 dte trades your spreadsheet would be simple enough to use but for those who make longer dte trades and have some adjustments I thought it might be better to use some RTD to keep track of each leg rather then just the total p/l for the trade
