Needed options Spreadsheet - Options on Futures | futures.io
futures io futures trading


Needed options Spreadsheet
Started: by elwoodpdowd Views / Replies:16,969 / 37
Last Reply: Attachments:4

Welcome to futures io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.


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, and we will never resell your private information.

-- Big Mike

Reply
 4  
 
Thread Tools Search this Thread
 

Needed options Spreadsheet

  #31 (permalink)
Trading Apprentice
HAWAII
 
Futures Experience: Intermediate
Platform: THINKORSWIM
Favorite Futures: OPTIONS
 
Posts: 3 since Apr 2016
Thanks: 2 given, 0 received

I need a Spreadsheet


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.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Hey Bro,
Can you send me a copy of the spreadsheets. w.edmonds@hotmail com

thanks

Reply With Quote
 
  #32 (permalink)
Trading Apprentice
HAWAII
 
Futures Experience: Intermediate
Platform: THINKORSWIM
Favorite Futures: OPTIONS
 
Posts: 3 since Apr 2016
Thanks: 2 given, 0 received

I need a Spreadsheet


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 w.edmonds@hotmail com

thanks

Reply With Quote
 
  #33 (permalink)
Trading Apprentice
Vail, CO USA
 
Futures Experience: Intermediate
Platform: ThinkorSwim
Favorite Futures: options
 
Martzee's Avatar
 
Posts: 12 since Jan 2015
Thanks: 6 given, 8 received

spreadsheet



Smith33 View Post
Hey Bro,

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

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
 
  #34 (permalink)
Trading Apprentice
Vail, CO USA
 
Futures Experience: Intermediate
Platform: ThinkorSwim
Favorite Futures: options
 
Martzee's Avatar
 
Posts: 12 since Jan 2015
Thanks: 6 given, 8 received


Smith33 View Post
Hey Bro,

can you send me a copy of the spreadsheet w.edmonds@hotmail com

thanks

Here is the new spreadsheet:
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Reply With Quote
 
  #35 (permalink)
Trading Apprentice
Dallas, Texas
 
Futures Experience: Beginner
Platform: TradeStation
Favorite Futures: Crude CL
 
Posts: 1 since Aug 2016
Thanks: 0 given, 0 received

Futures Edge on FIO

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.

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

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
 
  #36 (permalink)
Trading Apprentice
little rock arkansas usa
 
Futures Experience: Intermediate
Platform: AT Charts
Favorite Futures: crude cl
 
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
 
  #37 (permalink)
Trading Apprentice
Kirkland WA
 
Futures Experience: Beginner
Platform: NinjaTrader
Favorite Futures: Currency futures
 
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
 
  #38 (permalink)
Trading Apprentice
Detroit, MI/USA
 
Futures Experience: Beginner
Platform: TOS
Favorite Futures: GLD
 
Posts: 1 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

Reply With Quote

Reply



futures io > > > > Needed options Spreadsheet

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)
 

Spring Grains Outlook w/Sean Lusk @ Walsh Trading

Elite only

FIO Video Journal Challenge featuring NinjaTrader ($2,000+ of prizes)

April

Process above all else w/Anthony Crudele @ Futures Radio Show

Elite only

Machine Learning - Quantitative Trading w/Martin Froehler @ Quantiacs

Elite only

Market Dynamics w/Peter Davies @ Jigsaw Trading

Elite only

Ask Me Anything w/Patrick Rooney @ Trading Technologies

Apr 18

Ask Me Anything w/FuturesTrader71

Apr 19

Machine Learning w/Kris Longmore

Elite only

Market Analysis w/Dave Forss

Apr 25

Introducing iSystems with Stage 5 Trading

Apr 27
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Options Analysis Software for Options on Futures ChrisB Options on Futures 6 December 7th, 2012 04:47 AM
spreadsheet benrock Psychology and Money Management 8 October 13th, 2012 07:57 PM
spreadsheet novice PandaWarrior Psychology and Money Management 3 December 9th, 2010 08:12 PM
Modeling spreadsheet Saroj Traders Hideout 3 October 7th, 2009 09:12 AM
another spreadsheet to try out Saroj Psychology and Money Management 1 July 26th, 2009 06:45 AM


All times are GMT -4. The time now is 08:54 PM.

no new posts
Page generated 2017-03-30 in 0.14 seconds with 36 queries on phoenix via your IP 54.166.77.32