›

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

PortfolioSlicer 2.4 Invalid Account

TotopopsTotopops
in External Data Files
In the Transaction Section, entries older than 2020 are showing "Invalid Account" error. Is there a limit to the historical data in PortfolioSlicer v2.4?

Comments

  • VidasMatelisVidasMatelis
    edited February 18
    In "src" tab there is Local Config table. There is MinDate parameter - can you please make sure that the value is correct there - maybe your MinDate is 2020-01-01?
    There is no limit to historical data.
  • TotopopsTotopops
    I checked the minimum date value and it appears to be correct at 2016-04-06
    However, I think that I accidently deleted the initial transaction line that is marked "DO NOT DELETE". I tried to enter is again with the data on the initial file. I'm sure that this caused the problem that i am having.

    Is there a way of properly restoring that transaction line?
  • VidasMatelisVidasMatelis
    That first "Do Not Delete" transaction line is very important to address Excel limitations (first n rows to figure out the type of data in each column). I do not know of a safe/sure way to restore that transaction. Your options:
    1. Take an empty Source file and copy data there.
    2. Open empty source file and copy that "Do not Delete" row and paste into your Source workbook. It might work, but it might not work - no guarantees.
  • TotopopsTotopops
    Vidas,
    Thank you for your help. Your suggestion worked and I have been able to restore all of my historical data!
Sign In or Register to comment.