Options returning N/A

Discussion in 'Troubleshooting' started by twent2t, Apr 26, 2017.

Options returning N/A

Tags:
  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Will update later today.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Ok, Can you check again?
     
  3. twent2t

    twent2t Member

    Joined:
    Feb 14, 2016
    Messages:
    30
    Likes Received:
    4
    I am still receiving N/A on some options. They appear to be options which end with zero. I am now having N/A returned for vrsn170616c80 and vrsn170616c90. VRSN options that end in 5 work correctly. Please update on the solution.
     
  4. Grady Parker

    Grady Parker New Member

    Joined:
    Apr 26, 2017
    Messages:
    28
    Likes Received:
    2
    I'm getting NA's on one option, STX170616C00045000 and zero's on URI170616C00085000. Any idea what's going on?
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    I am checking this.
     
  6. pranilb

    pranilb New Member

    Joined:
    Feb 2, 2017
    Messages:
    6
    Likes Received:
    0
    still getting NA for AGI170616C00007500
     
  7. Grady Parker

    Grady Parker New Member

    Joined:
    Apr 26, 2017
    Messages:
    28
    Likes Received:
    2
    Still getting NA's on one option, STX170616C00045000 and zero's on URI170616C00085000.
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    I will get this fixed tonight after market closes.
     
  9. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Grady,

    Are you sure that this is a valid option for June 16th? Looks like there is none available for this strike price.
     
  10. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    The other one seems to work fine.

    upload_2017-5-11_21-25-16.png
     
  11. Grady Parker

    Grady Parker New Member

    Joined:
    Apr 26, 2017
    Messages:
    28
    Likes Received:
    2
    On STX170616C00045000 Fidelity is showing me 16 bid @ .48 and 8 offered at .51 right now. Also both the STX170519C00045000 and STX170721C00045000 options are showing the correct price. Also VLO170519P00062500 is showing bid .02 with ask .05 when this option is currently $4 in the money. Wish I could buy it at that price.
     
  12. Grady Parker

    Grady Parker New Member

    Joined:
    Apr 26, 2017
    Messages:
    28
    Likes Received:
    2
    On URI170616C00085000 the option is way in the money and the last price is way off (hasn't traded since 2/13/17), so it does no good. Again Fidelity shows 57 contracts bid at 27.10 and 43 contracts bid at 29.50 right now.
     
  13. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Ok, I am checking this Grady
     
  14. twent2t

    twent2t Member

    Joined:
    Feb 14, 2016
    Messages:
    30
    Likes Received:
    4
    Any updates on this problem? I just checked vrsn170616 and I get an N/A for the 90 option but I get the correct value for both the 85 and 95 option.
     
  15. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    Option_Last_Price produces "NA" for all stock codes...
     
  16. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi I checked it, seems to be working fine. Check =Lats("MSFT") does this work for you?
     
  17. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    =Last("MSFT")
    67.48

    =Option_Last_Price("MSFT170616P00067500")
    NA
     
  18. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    =Option_Last_Price("MSFT170616P00067500") gives me 1.3. Can you try a quick reinstall?
     
  19. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    Yes thanks uninstalled reinstalled...
    =Option_Bid("MSFT170616P00067500")

    Marketxls has fired an exception:

    Detailed technical information follows:
    ---
    (Inner Exception)
    (Inner Exception)
    Date and Time: 18/05/2017 21:42:02
    Machine Name: ASUS
    IP Address: fe80::f889:ae57:79a5:6e81%18
    Current User: ASUS\Don

    Application Domain: C:\Users\Don\AppData\Local\marketxls.com\marketxls\
    Assembly Codebase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    Assembly Full Name: System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
    Assembly Version: 4.0.0.0

    Exception Source: System.Configuration
    Exception Type: System.Configuration.ConfigurationErrorsException
    Exception Message: Unrecognized configuration section userSettings. (C:\Users\Don\AppData\Local\Microsoft_Corporation\C__Users_Don_AppData_Loca_Path_jojpsvsna1vaszvd35jsryd0vnvv001i\16.0.7967.2161\user.config line 3)
    Exception Target Site: ThrowIfErrors

    ---- Stack Trace ----
    System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(ignoreLocal As Boolean)
    System.Configuration.dll: N 0040 (0x28) IL
    System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(schemaErrors As ConfigurationSchemaErrors)
    System.Configuration.dll: N 0000 (0x0) IL
    System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors()
    System.Configuration.dll: N 0000 (0x0) IL
    System.Configuration.ClientConfigurationSystem.OnConfigRemoved(sender As Object, e As InternalConfigEventArgs)
    System.Configuration.dll: N 0030 (0x1E) IL



    (Outer Exception)
    Date and Time: 18/05/2017 21:42:02
    Machine Name: ASUS
    IP Address: fe80::f889:ae57:79a5:6e81%18
    Current User: ASUS\Don

    Application Domain: C:\Users\Don\AppData\Local\marketxls.com\marketxls\
    Assembly Codebase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    Assembly Full Name: System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
    Assembly Version: 4.0.0.0

    Exception Source: System.Configuration
    Exception Type: System.Configuration.ConfigurationErrorsException
    Exception Message: Configuration system failed to initialize
    Exception Target Site: PrepareConfigSystem

    ---- Stack Trace ----
    System.Configuration.ConfigurationManager.PrepareConfigSystem()
    System.Configuration.dll: N 0024 (0x18) IL
    System.Configuration.ConfigurationManager.RefreshSection(sectionName As String)
    System.Configuration.dll: N 0009 (0x9) IL
    System.Configuration.ClientSettingsStore.ReadSettings(sectionName As String, isUserScoped As Boolean)
    System.Configuration.dll: N 0039 (0x27) IL
    System.Configuration.LocalFileSettingsProvider.GetPropertyValues(context As SettingsContext, properties As SettingsPropertyCollection)
    System.Configuration.dll: N 0014 (0xE) IL
    System.Configuration.SettingsBase.GetPropertiesFromProvider(provider As SettingsProvider)
    System.Configuration.dll: N 0084 (0x54) IL
    System.Configuration.SettingsBase.GetPropertyValueByName(propertyName As String)
    System.Configuration.dll: N 0113 (0x71) IL
    System.Configuration.SettingsBase.get_Item(propertyName As String)
    System.Configuration.dll: N 0020 (0x14) IL
    System.Configuration.ApplicationSettingsBase.GetPropertyValue(propertyName As String)
    System.Configuration.dll: N 0043 (0x2B) IL
    System.Configuration.ApplicationSettingsBase.get_Item(propertyName As String)
    System.Configuration.dll: N 0020 (0x14) IL
    MarketXLS.My.MySettings.get_guser()
    System.Configuration.dll: N 0001 (0x1) IL
    MarketXLS.AddinModule.LicenseValid()
    System.Configuration.dll: N 0039 (0x27) IL
    MarketXLS.AddinModule.LicenseType()
    System.Configuration.dll: N 0022 (0x16) IL
    MarketXLS.AddinModule.RefreshNow_OnClick(sender As Object, control As IRibbonControl, pressed As Boolean)
    System.Configuration.dll: N 0006 (0x6) IL
    AddinExpress.MSO.ADXRibbonButton.DoInternalAction(e As ADXRibbonOnActionEventArgs)
    System.Configuration.dll: N 0035 (0x23) IL



    (Outer Exception)
    Date and Time: 18/05/2017 21:42:02
    Machine Name: ASUS
    IP Address: fe80::f889:ae57:79a5:6e81%18
    Current User: ASUS\Don

    Application Domain: C:\Users\Don\AppData\Local\marketxls.com\marketxls\
    Assembly Codebase: file:///C:/Users/Don/AppData/Local/marketxls.com/marketxls/AddinExpress.MSO.2005.DLL
    Assembly Full Name: AddinExpress.MSO.2005, Version=7.7.4087.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965
    Assembly Version: 7.7.4087.2005

    Exception Source:
    Exception Type: AddinExpress.MSO.ADXExternalException
    Exception Message: An error has occurred in the code of the add-in.
    Exception Target Site: Object reference not set to an instance of an object.

    ---- Stack Trace ----
     
  20. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    I re-installed program and re-entered the licence info and he option functions are working. Thanks for your help.
     
    marketxls likes this.

Share This Page