Open Interest change in options - futures io
futures io futures trading



Open Interest change in options


Discussion in Options

Updated
      Top Posters
    1. looks_one Giovanni14 with 2 posts (0 thanks)
    2. looks_two sam028 with 1 posts (0 thanks)
    3. looks_3 Tradelog with 1 posts (2 thanks)
    4. looks_4 HattieTheWitch with 1 posts (0 thanks)
    1. trending_up 2,405 views
    2. thumb_up 2 thanks given
    3. group 4 followers
    1. forum 4 posts
    2. attach_file 0 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
 

Open Interest change in options

(login for full post details)
  #1 (permalink)
Moscow + Russia
 
 
Posts: 2 since Nov 2014
Thanks: 1 given, 0 received

Hello. Sorry for my english, it is not my native language.
I have system based on analysis of options, I use it to trade forex. Need to calculate open interest change online. The idea is to construct a diagram where the open interest is changing in online mode through the day. Anyone have idea how to do this using excel?
P.S. I trade EUR/USD.

P.P.S. I think I've placed the post not to the right section. Admin, move it to the right section, please.

Reply With Quote

Journal Challenge February 2021 results:
Competing for $1500 in prizes from Topstep
looks_oneSBtrader82 's Trading Journalby SBtrader82
(173 thanks from 31 posts)
looks_twoJust BEING a Trader: Letting Go!!by iqgod
(120 thanks from 33 posts)
looks_3Wisdom is Emptinessby Mtype
(68 thanks from 25 posts)
looks_4Deetee’s DAX Trading Journal (time based)by Deetee
(35 thanks from 17 posts)
looks_5Journal for peanuts1956by peanuts1956
(23 thanks from 13 posts)
 
 
(login for full post details)
  #2 (permalink)
Fairfield, Ohio
 
 
Posts: 4 since Dec 2014
Thanks: 1 given, 0 received

You may want to ask your question in the foreign language (Russian) section of the Trader's Hideout.

Reply With Quote
 
(login for full post details)
  #3 (permalink)
Budapest Hungary
 
Experience: Intermediate
Platform: TOS, Interactive Brokers
Trading: Options
 
Posts: 13 since May 2012
Thanks: 3 given, 9 received



Giovanni14 View Post
Hello. Sorry for my english, it is not my native language.
I have system based on analysis of options, I use it to trade forex. Need to calculate open interest change online. The idea is to construct a diagram where the open interest is changing in online mode through the day. Anyone have idea how to do this using excel?
P.S. I trade EUR/USD.

P.P.S. I think I've placed the post not to the right section. Admin, move it to the right section, please.

You can do this in three steps with TOS.

1) Select your instrument on the Trade page and configure the columns of the options chain to include open interest.

2) On the upper right hand corner (Trade page) select Export to Microsoft Excel. Go to MS Excel and copy paste. Now in Excel you will see the entire options chain which is DDE based and is live data as long as TOS is open. Go to another worksheet and just link to the desired cell containing the open interest, make graphs or whatever you need.

3) If you need to capture an entire day of open interest to see how it has changed over the course of the day then it gets more tricky. You need a macro. You can find a great macro on this site with the exact same purpose.
Simple Copy and Update Cell Value Every Minute

Best

Reply With Quote
The following 2 users say Thank You to Tradelog for this post:
 
(login for full post details)
  #4 (permalink)
Site Moderator
 
 
sam028's Avatar
 
Posts: 3,665 since Jun 2009
Thanks: 3,786 given, 4,494 received

The first question is from where are you going to grab your data. IB, Yahoo, ...?

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
 
(login for full post details)
  #5 (permalink)
Moscow + Russia
 
 
Posts: 2 since Nov 2014
Thanks: 1 given, 0 received


sam028 View Post
The first question is from where are you going to grab your data. IB, Yahoo, ...?

Hello.
I use thinkorswim+Excel.

Reply With Quote


futures io Trading Community Traders Hideout Options > Open Interest change in options


Last Updated on February 4, 2015


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Battlestations! Show us your trading desk - $1,500 in prizes!

March
 

Call Option Buying: The New Pain Trade? w/Carley Garner

Elite only
 

Importance of Finding Your Own Way w/Adam Grimes

Elite only
 

New Challenge (TBD)

April
     



Copyright © 2021 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