›

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

(blank) in holdings?

jwengajwenga
in Excel Workbook
What is the cause of (blank) in holdings. I cannot figure it out. All srcTrans are correct. This blank has a very high symbol price leading me to believe its some index measurement but I do not have a blank anywhere.

Thanks,
Joe

Comments

  • VidasMatelisVidasMatelis
    Hi Joe,

    For every failed relationship PowerPivot engine ads "blank" value to make sure that relationship can be created. Most likely you have a quote, transaction or SymbolSector assignment for a symbol that does not exist. Then PowerPivot internally will add "Empty" symbol. I am guessing, most likely your issue is with quotes for symbols that do not exists in Symbol table. Then the high price you see is the sum of all symbol quotes that do not have record in the Symbol table.
  • jwengajwenga
    That was it. I had a market index in my script but not in my excel workbook. Thanks
Sign In or Register to comment.