Portfolio Management Add Transaction Date Code Error

Discussion in 'General Questions' started by daveatuw, Dec 7, 2016.

Portfolio Management Add Transaction Date Code Error

  1. daveatuw

    daveatuw New Member

    Joined:
    Nov 18, 2016
    Messages:
    4
    Likes Received:
    0
    Hi,

    I've found a number of bugs that make the portfolio management feature unusable.  I  believe you might have reversed the Days and Months in the datecode.  When I add transactions to my portfolio such that the DD > 12, I get the error below.  So, I have to manually alter  transaction dates (e.g. Feb. 16, 2016 doesn't work, I have to change to Feb. 1).

    [​IMG]

    [​IMG]

     

    Detailed technical information follows:
    ---
    (Inner Exception)
    Date and Time: 12/6/2016 4:38:41 PM
    Machine Name: XXXXXXX
    IP Address: XXXXXXX
    Current User: XXXXXXX

    Application Domain: C:\Users\XXXXXXX\AppData\Local\Apps\2.0\E2NL598A.4DW\YMZLTC85.0HP\marketxls_c345630e3d1f4aa0_0007.0000_9855075ebcc0174d\
    Assembly Codebase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
    Assembly Full Name: Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
    Assembly Version: 10.0.0.0

    Exception Source: Microsoft.VisualBasic
    Exception Type: System.InvalidCastException
    Exception Message: Conversion from string "" to type 'Date' is not valid.
    Exception Target Site: ToDate

    ---- Stack Trace ----
    Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(Value As String)
    Microsoft.VisualBasic.dll: N 0054 (0x36) IL
    Microsoft.VisualBasic.CompilerServices.Operators.CompareObject2(Left As Object, Right As Object, TextCompare As Boolean)
    Microsoft.VisualBasic.dll: N 3013 (0xBC5) IL
    Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectNotEqual(Left As Object, Right As Object, TextCompare As Boolean)
    Microsoft.VisualBasic.dll: N 0000 (0x0) IL
    MarketXLS.AddinModule.CleanListOfSelection()
    AddinModule.vb: line 14175, col 17, IL 0115 (0x73)
    MarketXLS.AddinModule.OnlyOneSelected()
    AddinModule.vb: line 4379, col 09, IL 0001 (0x1)
    MarketXLS.AddinModule.NewPortfolio_Click(sender As Object)
    AddinModule.vb: line 3920, col 09, IL 0382 (0x17E)
    AddinExpress.MSO.ADXCommandBarButton.OnButtonClick(button As ICommandBarButton, handled As Boolean&)
    Microsoft.VisualBasic.dll: N 0053 (0x35) IL

    (Outer Exception)
    Date and Time: 12/6/2016 4:38:41 PM
    Machine Name: XXXXXXX
    IP Address: XXXXXXX
    Current User: XXXXXXX

    Application Domain: C:\Users\XXXXXXX\AppData\Local\Apps\2.0\E2NL598A.4DW\YMZLTC85.0HP\marketxls_c345630e3d1f4aa0_0007.0000_9855075ebcc0174d\
    Assembly Codebase: file:///C:/Users/XXXXXXX/AppData/Local/Apps/2.0/E2NL598A.4DW/YMZLTC85.0HP/marketxls_c345630e3d1f4aa0_0007.0000_9855075ebcc0174d/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 ----

     

     
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Dave,

    Portfolio management is being worked from scratch. Apologies for the inconvenience.

    Kind regards
    Ankur
     

Share This Page