Reports Not Updating

Comments

• VidasMatelis

  January 1

  The scripts are the same for v2 and v3. But are you using v3 PS Reports?
  If you are using v3, you need to add a few more sections in psConfig.txt file - please compare files between versions.
  Also check files in c:\PortfolioSlicer\PSData folder - is there error.txt file there?
  Then check Quotes.csv file - are there quotes from Dec 31st?
• GBiasini

  January 3 edited January 3

  Vidas, Thank you for your response. I have compared v. 2 psConfig.txt file to the one in the latest download. They appear identical. For example, the purported v.3 file does not have the ExcelSourceFile lines. I added that one in before I ran the scripts. What other lines are required?
  
  There is no error.txt file in PSData folder. There are quotes from December 31 in Quotes.csv.
  
  Thanks again.
• VidasMatelis

  January 3

  From PSConfig.txt make sure:
  1. You have section ExcelSourceFile where PortfolioSlicer-Source.txt file location is specified.
  2. You have section PSDataFolder, where your specified the output location as
  C:\PortfolioSlicer\PSData
  
  If you PSDataFolder section is not there, then default output for scripts is \PSData\", where .. means your script location, so your output would go to different folder.
  
  Run bat file, and confirm that the "c:\PortfolioSlicer\PSData" folder has files with timestamp of "NOW", if that is not the case, then you are outputting somewhere else.
• GBiasini

  January 3 edited January 3

  Thanks again for your very prompt response. I Have the ExcelSourceFile pointing where the PortfolioSlicer-Source.txt file is. I have the section PSDataFolder line left blank. I ran the bat file and can confirm that "c:\Users\Gary\OneDrive\PortfolioSlicer\PSData" folder has files with timestamp of "NOW".
  
  I ran the update on the workbook and still show the refresh time, etc. as December 30.
  
  Where else may I look?
• VidasMatelis

  January 3

  By default, your Excel files are reading output files from c:\PortfolioSlicer\PSData folder.
  If you have not modified Excel files, then you need to set value for PSDataFolder section to c:\PortfolioSlicer\PSData
• GBiasini

  January 4 edited January 4

  Thanks. I set the value to point to my PSData folder "C:\Users\garyb\Onedrive\PortfolioSlicer\PSData" and no difference.
• VidasMatelis

  January 4

  After you set the value and executed the scripts, can you please review folder c:\PortfolioSlicer\PSData - are timestamps on the files in that folder represent current date/time?
  
• GBiasini

  January 4

  Yes, they are.
• GBiasini

  January 4

  Vidas, I changed the line from "C:\Users\garyb\Onedrive\PortfolioSlicer\PSData" to "c:\PortfolioSlicer\PSData" and now it works. If I want my PSData file to remain at "C:\Users\garyb\Onedrive\PortfolioSlicer\PSData", what do I need to do?
• VidasMatelis

  January 4

  By default, Excel Reports file is loooking for files in c:\PortfolioSlicer\PSData folder. If you want this to be different folder, you need to first update PSDataFolder in PSConfig.txt and after that you need to edit Excel Report file and change the location of all external files. Example on how to do that is in this document:
  https://www.portfolioslicer.com/docs/excel2013-change-data-location.html
• GBiasini

  January 4

  Thank you very much for your input.