Premium decay analysis excel sheet-free download

Premium decay analysis excel sheet-free download

Stock futures August 29, 2019

Premium decay analysis excel sheet-free download


Premium decay analysis excel sheet-free download


  1. We update the option chain historical data daily for free
  2. Subscribe to our blog to get the latest updates
  3. Download monthly option chain excel sheet from  here

If you want to record the premium decay by yourself follow this procedure

  1. Download 2 excel file from the link Book1 and Option chain premium decay file from link  2 link
  2. Place both files in desktop
  3. Open Book 1 go-to data click the new query
  4. Click data source setting
  5. Click change source-Browse-select the downloaded file from the desktop-Import
  6. Visit NSE.COM 
  7. Copy all data of option chain
  8. Paste the data in Book1 File
  9. Save and close the Book1 file
  10. Open the Option chain premium decay file 
  11. Go to data and click refresh 
  12. Press ctrl+q on  Premium change sheet 
  13. Analyze the data as per blog 
  14. If the above procedure does not work for you. We will update the file you can download the file from this link and do the analysis
Leave your comment in the comment box whether it is helpful to you or not and your topic you want to read. We will improve based on your suggestions.

The truth of the brokerage industry, Trading expert & retail traders

How professional traders trade?

Working principle of stock market 


Tags

Post a Comment

12 Comments

  1. UnknownSeptember 4, 2019 at 8:38 PM

    bro point ---Open Book 1 go-to data click the new query
    Click data source setting
    Click change source-Browse-select the downloaded file from the desktop-Import
    kuch palle nahi pad raha hai .

    ReplyDelete
    Replies
    1. Stock futuresSeptember 4, 2019 at 8:59 PM

      If you wan to record the option chain data by yourself follow the procedure otherwise you can downlad the weekly and monthly option chain data from the link provided at the start. If you want anything else comment in relative blog page.

      Delete
  2. RajuSeptember 17, 2019 at 12:20 AM

    if both sides premium decay is same or negative what will happen ?

    ReplyDelete
  3. Stock futuresSeptember 17, 2019 at 8:10 AM

    premium decay is same or negative it means new position created by the progessional traders or closed older position

    ReplyDelete
  4. AnonymousDecember 29, 2019 at 1:01 AM

    Hi,
    Can we get updated premium decay analysis sheet on daily basis in your website? if yes,where and how to get it here? if no,how to do it ourselves?

    ReplyDelete
    Replies
    1. Stock futuresJanuary 27, 2020 at 8:15 PM

      Yes you can get premium decay excel sheet every day

      Delete
  5. AnonymousDecember 29, 2019 at 8:30 PM

    Excellent work , keep it up

    ReplyDelete
  6. sumitApril 10, 2020 at 2:31 PM

    how to automate this premium decay sheet so that we can use it live market

    ReplyDelete
  7. ankitApril 30, 2020 at 4:48 PM

    this is only capturing net change....is that wht is required to get the direction

    ReplyDelete
  8. SANTANU MONDALMay 18, 2020 at 12:15 PM

    Sir where we can find the VWAP of
    option price?

    ReplyDelete
  9. Ravi KhannaMay 19, 2020 at 6:47 PM

    Not getting new query option in excel 2019. can you pls help me?

    ReplyDelete
  10. UnknownAugust 16, 2020 at 12:22 AM

    Sir, from Sep month, the old website will be not available. Then will the excell sheets will work ? That means how to fetch data from the website ?

    ReplyDelete

Thank you for your valuable comment