Needed options Spreadsheet - futures io
futures io



Needed options Spreadsheet


Discussion in Options

Updated
      Top Posters
    1. looks_one elwoodpdowd with 8 posts (2 thanks)
    2. looks_two RedK with 3 posts (1 thanks)
    3. looks_3 Smith33 with 3 posts (0 thanks)
    4. looks_4 No2Fool with 3 posts (1 thanks)
      Best Posters
    1. looks_one dave01 with 3.5 thanks per post
    2. looks_two sam028 with 3 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 32,404 views
    2. thumb_up 34 thanks given
    3. group 32 followers
    1. forum 45 posts
    2. attach_file 10 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Needed options Spreadsheet

(login for full post details)
  #21 (permalink)
marscormeir
Moncton
 
 
Posts: 3 since Aug 2014
Thanks: 0 given, 0 received

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 futures io?
TD Sequential for NT or MW?
Platforms and Indicators
TradingView help in improving Anchored Vwap
Platforms and Indicators
Eurex Denali vs dxFeed
Sierra Chart
Experience with AGN (Introducing Broker)
Brokers
Time Segmented Volume
NinjaTrader
 
 
(login for full post details)
  #22 (permalink)
dave01
Salt Lake City, UT/USA
 
 
Posts: 10 since Mar 2015
Thanks: 0 given, 11 received

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:
 
(login for full post details)
  #23 (permalink)
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
 
elwoodpdowd's Avatar
 
Posts: 13 since Sep 2012
Thanks: 8 given, 6 received


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:
 
(login for full post details)
  #24 (permalink)
No2Fool
Memphis, TN
 
 
Posts: 4 since Jul 2013
Thanks: 1 given, 1 received


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
 
(login for full post details)
  #25 (permalink)
No2Fool
Memphis, TN
 
 
Posts: 4 since Jul 2013
Thanks: 1 given, 1 received


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:
 
(login for full post details)
  #26 (permalink)
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
 
elwoodpdowd's Avatar
 
Posts: 13 since Sep 2012
Thanks: 8 given, 6 received

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
 
(login for full post details)
  #27 (permalink)
dave01
Salt Lake City, UT/USA
 
 
Posts: 10 since Mar 2015
Thanks: 0 given, 11 received

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:
 
(login for full post details)
  #28 (permalink)
 elwoodpdowd 
Seattle, WA/United States
 
Experience: None
Platform: think or swim
Trading: options
 
elwoodpdowd's Avatar
 
Posts: 13 since Sep 2012
Thanks: 8 given, 6 received


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:
 
(login for full post details)
  #29 (permalink)
stallion2008
Los Angeles California USA
 
 
Posts: 1 since Nov 2011
Thanks: 1 given, 0 received

Greetings guys,

I would love a copy of this options Spreadsheet.

Does anyone have a link

Thanks in advance

Reply With Quote
 
(login for full post details)
  #30 (permalink)
Smith33
HAWAII
 
 
Posts: 3 since Apr 2016
Thanks: 2 given, 0 received



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. [email protected]

thanks

Reply With Quote


futures io Trading Community Traders Hideout Options > Needed options Spreadsheet


Last Updated on February 19, 2021


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing

Your Charts Should Speak To You w/Bob Cometta

Elite only
 

Our 12-year anniversary w/ $$,$$$ prizes (check soon)

August
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), info@futures.io
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.
no new posts