+ Reply to Thread
Results 1 to 4 of 4

Options Trading And Excel

  1. #1
    Registered User
    Join Date
    03-07-2020
    Location
    Arizona
    MS-Off Ver
    2020
    Posts
    3

    Options Trading And Excel

    Hello,

    I’m looking to hire someone to help me build some Excel Spreadsheets for Options Trading. If you are an Options Trader or at least know about Options that would be extremely beneficial.

    For example of what I am looking for one of the sheets to provide is:

    Calculates expected moves using real time market IV data and historical reference data to generate optimum buying/selling opportunities based on current underlying movement.
    Instantly identify volatility buying/selling opportunities based on market conditions from one page
    Implied Volatility and option price grid per term, 10 terms out
    Average True Range (ATR) and realized volatility tests for Days to Expiration (DTE)
    Option Fair Value and optimum edge values per term
    Real Time IV data combined with historical data in multiple time frames
    All Term option purchasing risk/reward profiles for Average True Range (ATR) and Historical Volatility (HV)
    Historical context from standard deviation for reference in all terms


    I need it to be able to connect to my Trading platform - I use Sterling Trader Pro which has an Excel Plugin option to be able to get RTD.


    If someone can help me out with this, send me a message please.

  2. #2
    Registered User
    Join Date
    03-07-2020
    Location
    Arizona
    MS-Off Ver
    2020
    Posts
    3

    Re: Options Trading And Excel

    Anyone think they can help me out with this?

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Options Trading And Excel

    I think you should try to be a bit more patient. You have bumped your thread after only 12 hours (the expected norm is 24 hours). It is a weekend, and you have made a specific request for someone with experience of Options Trading to help you.

    I don't know if there are any on the forum, but they might be enjoying their weekend and not bothering to check threads at the moment (this forum is staffed by volunteers).

    Pete

  4. #4
    Registered User
    Join Date
    03-07-2020
    Location
    Arizona
    MS-Off Ver
    2020
    Posts
    3
    You’re right - I did not take that into consideration. My apologies. Just eager to finding someone to help me with this.

    Thanks for your input. I appreciate it.


    Quote Originally Posted by Pete_UK View Post
    I think you should try to be a bit more patient. You have bumped your thread after only 12 hours (the expected norm is 24 hours). It is a weekend, and you have made a specific request for someone with experience of Options Trading to help you.

    I don't know if there are any on the forum, but they might be enjoying their weekend and not bothering to check threads at the moment (this forum is staffed by volunteers).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel macro for backtesting trading strategies
    By Trader_Test in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2021, 05:38 PM
  2. Replies: 0
    Last Post: 08-21-2019, 06:12 AM
  3. How do i calculate this stocks trading excel?
    By nederay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2013, 03:25 AM
  4. Excel trading calculator
    By tigorin in forum Excel General
    Replies: 0
    Last Post: 01-13-2013, 04:23 PM
  5. VBA or excel code for trading blotter
    By Mr. F in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 11:13 AM
  6. Excel sheet for trading system
    By smarttj1027 in forum Excel General
    Replies: 0
    Last Post: 06-02-2010, 05:39 AM
  7. i want a excel template for share trading
    By Bryan in forum Excel General
    Replies: 0
    Last Post: 10-15-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1