Basic Description: I'm using Excel 2003. This will be applied to trading Oil contracts. Selling and Buying both Put and Call Options. Trades that are executed on any day will be exported from the Trading Platform and imported into an Excel Position Tracker. This Position Tracker is a live record of all trades that have been imported from the trade logs, and will keep a running total of Profit/Loss.
The Job: Create an executable that will import a daily trade log (already exported from the trading platform by me) into the position tracker and append the positions, and update credit received/loss for the trades and net total profit/loss to date.
Included examples information: I currently trade Covered Calls and Cash Secured Puts (CSP) with a philosophy and strategy known as Systematic Covered Writing (SysCW). I purchased report data manager software the does what I describe above, but with Covered Calls and CSPs. It doesn't know how to handle Strangles or Vertical Spreads. The Joe Roth Example I provided is my actual position tracker for my Roth IRA trading account. Its just to give you an idea of what I'm after. When I run the data manager, I get an input window (screenshot attached). I put in my current Position Tracker file, my Trade Log for the day, and the name of the file I want to call the updated report. Assignment Fee and Dollar Cost Averaging are NOT NEEDED for what I'm asking for here. I run it and the positions are updated and credit/loss are posted.
For this new Position Tracker that I want to hire out, it is only intended for Strangles and Spreads. (See the Strangle and Spreads examples attached).
10 Feb 17, I sell a Strangle on Oil
Sell 2 March 65 Calls for 0.08 Credit. ($80 since Oil is a 1000 X of the credit)
Sell 2 March 40 Puts for 0.07 Credit ($70 " " )
Commission cost is $5.50 for the Calls and $5.50 for the Puts. Net Credit received is $80 + $70 - $11, or $139. Running the data manager posts this data in my position tracker.
3 Weeks later, I decide to close these positions (or even just one).
1 Mar 17, I close the position in its entirety.
Buy 2 March 65 Calls for 0.01 Debit. (-$10 since Oil is a 1000 X of the credit)
Buy 2 March 40 Puts for 0.01 Debit (-$10 " " )
Commission cost is $5.50 for the Calls and $5.50 for the Puts. Net Debit: -$31
Since contracts will be continually opened or closed, the data manager need so be able to compare the trade log position to an open position that matches the Underlying (CL in this case) and post the changes (close the position, add new ones).
The position tracker you create won't look like the example I provided but I would like to keep the ability to separate transactions on different underlying stocks. I may trade a strangle on CL, IWM, SPY and DIA and would like those to stay segregated. It will just be posting new positions, closing old ones, and adding the credit/debit/commissions. We won't worry about a % Return.
One last thing, the data manger needs to be able to show any open positions as Expired if the Expiration Date is reached and the underlying price is Above an open short Put, or Below and open short Call, and move the position to the Closed Position section. My example position tracker uses the Stock Symbols and Quote tab for that. I update the Quote tab before posting any new positions. Both tabs are probably usable just as they are and have the macro for obtaining the latest prices. All closed positions need moved to the Closed section as well.
I think that's enough for now. More details later if needed.
7 freelance ont fait une offre moyenne de 370 $ pour ce travail
Hello I am Developer Excel expert and VBA programmer I would like to offer you my service and write softs for you If you are interested, PM me Thanks & Regards
Hi I have got extensive virtual operation managing experience under my belt so far in different industries/feilds. Hoping to hear from you asap inorder to take it further.