Fill in a Spreadsheet with Data

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.

Compétences : Saisie de Données, Traitement de Données, Excel

en voir plus : https www freelancer com projects data entry fill spreadsheet with data 10799431, https://wwwfreelancercom/projects/data-entry/fill-spreadsheet-data-entry/, data-entry/fill-spreadsheet-with-data-entry, FILL DATA SPREADSHEET, php form data spreadsheet, macro cut data spreadsheet copy different spreadsheet, vba macro cut data spreadsheet spreadsheet, excel macro script insert data spreadsheet, contact data spreadsheet, collecting price data spreadsheet, macro data spreadsheet, payroll data spreadsheet, link web data spreadsheet, 2008 extract data spreadsheet, putting tech support data spreadsheet

Concernant l'employeur :
( 1 commentaire ) Wellsville, United States

Nº du projet : #12700735

Décerné à:


Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Have done something like your project before for a trader, call and put options.. Am confident to do th Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(3 Commentaires)

7 freelance font une offre moyenne de $370 pour ce travail


Hello, I am ready to copy paste data from website/Pdf file to excel manually or auto. Please provide me exact source of data so i can check quantity of data and can quote you exact amount and time of delivery. LETS Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(180 Commentaires)

Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(188 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(21 Commentaires)

Hi, Thank you for contacting me, The Excel Master. I am also experienced in dealing with trading data. Including options trading. I also understand various trading strategies and that will help me do this job. I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

Good Day, I have been doing data entry for 3 years now- both paid and unpaid- and the responses I get back are always positive. I have a great work ethic and will not stop working until I and my client are happy with Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)