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)
  #31 (permalink)
Smith33
HAWAII
 
 
Posts: 3 since Apr 2016
Thanks: 2 given, 0 received


dave01 View Post
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.


Hey Bro,
Can you send me a copy of the spreadsheets. [email protected] com

thanks

Reply With Quote

Can you help answer these questions
from other members on futures io?
Portfolio Management Tool/Software
Psychology and Money Management
TD Sequential for NT or MW?
Platforms and Indicators
TradingView help in improving Anchored Vwap
Platforms and Indicators
Time Segmented Volume
NinjaTrader
ADR for Tradestation
TradeStation
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Webinar: Happy Hour w/Cem Karsan
37 thanks
Avoiding Account Killing Freight Trains
27 thanks
QG mini Natural Gas ( Position size ) calculation
19 thanks
The Beast Slayer, Lances NQ Trading Journal
16 thanks
Losing faith...
13 thanks
 
(login for full post details)
  #32 (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 the spreadsheet [email protected] com

thanks

Reply With Quote
 
(login for full post details)
  #33 (permalink)
Martzee
Vail, CO USA
 
 
Posts: 12 since Jan 2015
Thanks: 6 given, 9 received



Smith33 View Post
Hey Bro,

Can you send me a copy of your spreadsheet. [email protected]

thanks

I no longer use that spreadsheet. I have a different one, basically a single spreadsheet for a single stock ans a summary. If you want you can join our trading group on Facebook and download it there: https://www.facebook.com/groups/putdividends/

Reply With Quote
 
(login for full post details)
  #34 (permalink)
Martzee
Vail, CO USA
 
 
Posts: 12 since Jan 2015
Thanks: 6 given, 9 received


Smith33 View Post
Hey Bro,

can you send me a copy of the spreadsheet [email protected] com

thanks

Here is the new spreadsheet:

Reply With Quote
 
(login for full post details)
  #35 (permalink)
bobbymays
Dallas, Texas
 
 
Posts: 1 since Aug 2016
Thanks: 0 given, 0 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.


Hi, did anyone happen to get a link or an attachment for this spreadsheet? I would love to try to fit it for my needs. I appreciate it!

Reply With Quote
 
(login for full post details)
  #36 (permalink)
Biff1312
little rock arkansas usa
 
 
Posts: 3 since Sep 2016
Thanks: 0 given, 0 received


bobbymays View Post
Hi, did anyone happen to get a link or an attachment for this spreadsheet? I would love to try to fit it for my needs. I appreciate it!

would like to check this monitor spreadsheet out as well

Reply With Quote
 
(login for full post details)
  #37 (permalink)
lapem
Kirkland WA
 
 
Posts: 1 since Jan 2016
Thanks: 0 given, 0 received

Is Dave01 still active in futures.io? Does anyone know how to reach him, or where a copy of his trade log spreadsheet can be downloaded?

Reply With Quote
 
(login for full post details)
  #38 (permalink)
 bfumakiya 
Detroit, MI/USA
 
Experience: Beginner
Platform: TOS
Broker: TOS, Tastywork
Trading: Option n futures
 
Posts: 4 since Mar 2017
Thanks: 0 given, 0 received


elwoodpdowd View Post
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

can you send me PLEASE spreadsheet to bfumakiya at hot mail

Follow me on Twitter Reply With Quote
 
(login for full post details)
  #39 (permalink)
 Rambo 
Buenos Aires
 
Experience: Advanced
Platform: Ninja trader & Oec
Broker: Daniels Trading / Open e Cry
Trading: futures
 
Rambo's Avatar
 
Posts: 4 since Feb 2010
Thanks: 4 given, 7 received

I never find a spreadsheet how I need, so I had to do myself using a previous model (B&S approach).

There are some print screens, if somebody want it, just write me! Some pages are working 100% but others 80% and others 50%, I have to finish it!

cheers!

Attached Thumbnails
Click image for larger version

Name:	opt1.jpg
Views:	219
Size:	356.0 KB
ID:	238658   Click image for larger version

Name:	opt2.jpg
Views:	212
Size:	593.7 KB
ID:	238659   Click image for larger version

Name:	opt3.jpg
Views:	214
Size:	522.2 KB
ID:	238660   Click image for larger version

Name:	opt4.jpg
Views:	189
Size:	240.6 KB
ID:	238661   Click image for larger version

Name:	opt5.jpg
Views:	235
Size:	595.1 KB
ID:	238662  
Follow me on Twitter Reply With Quote
The following 2 users say Thank You to Rambo for this post:
 
(login for full post details)
  #40 (permalink)
TFOpts
Los Angeles, CA
 
 
Posts: 64 since May 2017
Thanks: 49 given, 136 received



Rambo View Post
I never find a spreadsheet how I need, so I had to do myself using a previous model (B&S approach).

There are some print screens, if somebody want it, just write me! Some pages are working 100% but others 80% and others 50%, I have to finish it!

cheers!

Rambo, looks pretty impressive. Would you be willing to share your spreadsheet on this thread?

Reply With Quote
The following user says Thank You to TFOpts for this post:


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