Needed options Spreadsheet - Options on Futures | futures io social day trading
futures io futures trading


Needed options Spreadsheet
Updated: Views / Replies:19,843 / 40
Created: by elwoodpdowd Attachments:10

Welcome to futures io.

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

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • 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.

-- Big Mike, Site Administrator

Reply
 10  
 
Thread Tools Search this Thread
 

Needed options Spreadsheet

  #21 (permalink)
Trading Apprentice
Moncton
 
Futures Experience: Beginner
Platform: MT4
Favorite Futures: SPX
 
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
 
  #22 (permalink)
Trading Apprentice
Salt Lake City, UT/USA
 
Futures Experience: Advanced
Platform: TOS
Favorite Futures: Index options, Futures Options
 
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.

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

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

Spreadsheet


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

Reply With Quote
The following user says Thank You to elwoodpdowd for this post:
 
  #24 (permalink)
Trading Apprentice
Memphis, TN
 
Futures Experience: Beginner
Platform: Think or Swim
Favorite Futures: Stocks
 
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
 
  #25 (permalink)
Trading Apprentice
Memphis, TN
 
Futures Experience: Beginner
Platform: Think or Swim
Favorite Futures: Stocks
 
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:
 
  #26 (permalink)
Elite Member
Seattle, WA/United States
 
Futures Experience: None
Platform: think or swim
Favorite Futures: options
 
elwoodpdowd's Avatar
 
Posts: 13 since Sep 2012
Thanks: 8 given, 6 received

Spreadsheet

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

Reply With Quote
 
  #27 (permalink)
Trading Apprentice
Salt Lake City, UT/USA
 
Futures Experience: Advanced
Platform: TOS
Favorite Futures: Index options, Futures Options
 
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.

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

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

Spreadsheet is perfect.


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).

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

Reply With Quote
The following user says Thank You to elwoodpdowd for this post:
 
  #29 (permalink)
Trading Apprentice
Los Angeles California USA
 
Futures Experience: Intermediate
Platform: Tradestation
Favorite Futures: option
 
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
 
  #30 (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 your spreadsheet. w.edmonds@hotmail

thanks

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)
 

RandBots: AutoTrading Bots to diversify your trading

Oct 24
 

TopstepTrader: Profiting Without Risking Your Own Money

Oct 26

Building Open Source Indicators for NT8 w/Fat Tails @ Lizard Indicators

Elite only
     

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 05:00 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, 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
Page generated 2017-10-23 in 0.15 seconds with 40 queries on phoenix via your IP 54.166.199.178