NexusFi: Find Your Edge


Home Menu

 





Needed options Spreadsheet


Discussion in Options

Updated
      Top Posters
    1. looks_one elwoodpdowd with 8 posts (3 thanks)
    2. looks_two RedK with 3 posts (1 thanks)
    3. looks_3 No2Fool with 3 posts (1 thanks)
    4. looks_4 Martzee with 3 posts (5 thanks)
      Best Posters
    1. looks_one dave01 with 3.5 thanks per post
    2. looks_two sam028 with 3.5 thanks per post
    3. looks_3 Rambo with 3 thanks per post
    4. looks_4 Martzee with 1.7 thanks per post
    1. trending_up 39,102 views
    2. thumb_up 36 thanks given
    3. group 33 followers
    1. forum 45 posts
    2. attach_file 10 attachments




 
Search this Thread

Needed options Spreadsheet

  #21 (permalink)
marscormeir
Moncton
 
Posts: 3 since Aug 2014
Thanks Given: 0
Thanks Received: 0

Can anyone share this doc or link? I am unable to send PMs ;(

thanks in advance,
Marcel



Martzee View Post
I use Google Spreadsheet for this purpose because this allows me to have the spreadsheet accessible from any computer anywhere and anytime.

I am not yet allowed to post links so PM me and I can share it with you. Bellow is a picture of what I use. I can also help you with what you need (but only in Google spreadsheet as my Excel knowledge of financial and date feed functions is limited).


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Request for MACD with option to use different MAs for fa …
NinjaTrader
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
58 thanks
Battlestations: Show us your trading desks!
50 thanks
NexusFi site changelog and issues/problem reporting
47 thanks
GFIs1 1 DAX trade per day journal
32 thanks
What percentage per day is possible? [Poll]
31 thanks

  #22 (permalink)
dave01
Salt Lake City, UT/USA
 
Posts: 10 since Mar 2015
Thanks Given: 0
Thanks Received: 11

I use two spreadsheets, one that is updated "realtime" by TOS and is my monitoring spreadsheet, and another that is my historical P&L tracking spreadsheet. I've made some very elaborate spreadsheets in the past, but I found that building and using them detracted from my trading.

As of just a month ago, I've greatly simplified my spreadsheets. My new spreadsheets are simple, but are a bit more hands on when adding new trades and making adjustments. It takes some experimentation to find what works best for you. For what it's worth, I've attached a screenshot of my monitoring spreadsheet so that you can get an idea of the column layout.

All of the TOS updated cells have formulas similar to: =RTD("tos.rtd",,"MARK",B3)
Where B3 is a reference to the underlying that I want the mark/mid price.


Reply With Quote
The following 5 users say Thank You to dave01 for this post:
  #23 (permalink)
 
elwoodpdowd's Avatar
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
Posts: 13 since Sep 2012
Thanks Given: 8
Thanks Received: 7


Good Morning,
First of all, thank you for responding to my request it was very generous of your effort and time. The spreadsheet is exactly what I'm looking for but and this is a big but, what do I do with it now. How do I get it into Excel? How does it link to TOS? As you may have guessed it is obvious I know very little to nothing about spreadsheets or Excel for that matter. Would you mind guiding me to getting this set-up, I spend more time trying to keep accurate records that it is ridiculous. Let me know and thank you once again.

Elwood P. Dowd

Started this thread Reply With Quote
The following user says Thank You to elwoodpdowd for this post:
  #24 (permalink)
No2Fool
Memphis, TN
 
Posts: 4 since Jul 2013
Thanks Given: 1
Thanks Received: 1


elwoodpdowd View Post
Good Morning,
First of all, thank you for responding to my request it was very generous of your effort and time. The spreadsheet is exactly what I'm looking for but and this is a big but, what do I do with it now. How do I get it into Excel? How does it link to TOS? As you may have guessed it is obvious I know very little to nothing about spreadsheets or Excel for that matter. Would you mind guiding me to getting this set-up, I spend more time trying to keep accurate records that it is ridiculous. Let me know and thank you once again.

Elwood P. Dowd

Were you able to download a spreadsheet? I did not see a dl link

Reply With Quote
  #25 (permalink)
No2Fool
Memphis, TN
 
Posts: 4 since Jul 2013
Thanks Given: 1
Thanks Received: 1


marscormeir View Post
Can anyone share this doc or link? I am unable to send PMs ;(

thanks in advance,
Marcel

I never got a reply either. Would love to know how to use that spreadsheet or a source of a good excel or other spreadsheet for option trade tracking.

Thanks for any help/

Reply With Quote
The following user says Thank You to No2Fool for this post:
  #26 (permalink)
 
elwoodpdowd's Avatar
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
Posts: 13 since Sep 2012
Thanks Given: 8
Thanks Received: 7

Hello There,
The monitor spreadsheet is actually what I need. Is there anyway I can import it or whatever one does to put it into my Excel? I can appreciate the lameness in my request but this business is totally foreign to me. If not, thanks once again for your time.

Elwood

Started this thread Reply With Quote
  #27 (permalink)
dave01
Salt Lake City, UT/USA
 
Posts: 10 since Mar 2015
Thanks Given: 0
Thanks Received: 11

Here's a screenshot of my updated monitor spreadsheet. This should give you some ideas for creating your own spreadsheet.

The cells in orange contain user entered values, while other cells contain either formulas or TOS RTD links. Columns L, N, O, P, and Q contain straight calls to TOS RTD. The remaining (non-orange) cells contain formulas using the data from the orange user entered data cells and/or the TOS RTD cells.


Reply With Quote
The following 2 users say Thank You to dave01 for this post:
  #28 (permalink)
 
elwoodpdowd's Avatar
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
Posts: 13 since Sep 2012
Thanks Given: 8
Thanks Received: 7


dave01 View Post
Here's a screenshot of my updated monitor spreadsheet. This should give you some ideas for creating your own spreadsheet.

The cells in orange contain user entered values, while other cells contain either formulas or TOS RTD links. Columns L, N, O, P, and Q contain straight calls to TOS RTD. The remaining (non-orange) cells contain formulas using the data from the orange user entered data cells and/or the TOS RTD cells.


Good Morning Dave,
Happy 4th of July and hope you have many more. The spreadsheet is perfect and I can't thank you enough for the effort.
Have a great day!

Elwood

Started this thread Reply With Quote
The following user says Thank You to elwoodpdowd for this post:
  #29 (permalink)
stallion2008
Los Angeles California USA
 
Posts: 1 since Nov 2011
Thanks Given: 1
Thanks Received: 0

Greetings guys,

I would love a copy of this options Spreadsheet.

Does anyone have a link

Thanks in advance

Reply With Quote
  #30 (permalink)
Smith33
HAWAII
 
Posts: 3 since Apr 2016
Thanks Given: 2
Thanks Received: 0



Martzee View Post
I use Google Spreadsheet for this purpose because this allows me to have the spreadsheet accessible from any computer anywhere and anytime.

I am not yet allowed to post links so PM me and I can share it with you. Bellow is a picture of what I use. I can also help you with what you need (but only in Google spreadsheet as my Excel knowledge of financial and date feed functions is limited).

Hey Bro,

Can you send me a copy of your spreadsheet. w.edmonds@hotmail

thanks

Reply With Quote





Last Updated on February 19, 2021


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts