›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Could Not get data from the data model

JerryJerry
in General
I am a new user to PS and need some assistance please. I am using V2.3-XL16 and have inputted my initial data in the src and srcSymbol tabs. When I go to holdings and refresh for the first time I am getting this error message. "Could not get data from the data model the "AttributeRelationship" with AttributeID=TranID doesn't exist in the collection" Appreciate any help you can provide.
Thanks
Jerry

Comments

  • VidasMatelisVidasMatelis
    This error means that Excel was not able to load Excel tables into data model. Usually this is because:
    1. You deleted first record in srcTrans table.
    2. You have any errors in srcTrans table. Error here could be - instead of numeric value you have string value or date value you specified cannot be loaded. In some cases these errors could be in cells that are red, in other cases not. Or error could be empty line at the end of the table. Please make sure you understand how to identify empty lines at your tables,
    3. You might have errors in other tables, like Account, ReportCurrent (often), symbol alias.

    More info about errors, empty lines available here: http://portfolioslicer.com/docs/excel-enter-table-data.html

    If you still have issues, please send me your workbook (my email posted on this page: http://www.portfolioslicer.com/contact.html)
  • JerryJerry
    The culprit was item 1, now it works like a charm. Thanks for the support
Sign In or Register to comment.