›

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

Refresh Time not updating

fsrobyfsroby
in General
I just ran my update script for the first time in a few weeks. The "Latest Quote Date" shows today (Sept. 05, 2025) but the "Refresh Time" shows August 15. Also my September dividends are not showing up. This is happeneing in both power-BI and the regular excel reports. I think I'm on the latest release as of August.
Any suggestions?

Comments

  • fsrobyfsroby
    This is the "refresh time" I am referring. On the Subscription tab in the Power BI version


  • VidasMatelisVidasMatelis
    edited September 9
    "Refresh time" field is from Config . csv file. This file is created with script GetExcelSrcData dot ps1 is executed and really reflects the time when this script was executed. So you need to follow this script execution.
    In the folder Scripts \ Log folder check the file GetExcelSrcData . txt First - what is the date time for this file Sep 9th, or Aug 15th?
    What is the content of the file?
    And then, please open file c: \ PortfolioSlicer \ PSData \ Config.csv - please post the content of that file here.
  • fsrobyfsroby
    All of the file dates in the Scripts/Log folder are of today's date.
    The content of the file is "17:33:21 --- Starting script GetExcelSrcData.ps1"
    The content of the PSData/Config.csv is:
    MinDate TrackCash RefreshTime
    2016-12-30 Yes Aug-15, 18:41


  • VidasMatelisVidasMatelis
    In the log file GetExcelSrcData.txt I expect at least 2 rows, for example:
    20:10:34 --- Starting script GetExcelSrcData.ps1
    20:10:41 --- Finished ExtractExcelData. Duration: 6 sec.

    If there is no "Finished" line, that is likely because of some error. But if there would be an error, then PSData\Config.csv would not be created, yet it is. Can you please check c:\PortfolioSicer\PSData\Config.csv file and see the date when the files was created. Is the file date is from Aug-15?
  • fsrobyfsroby
    created on Aug-15
  • VidasMatelisVidasMatelis
    So there is an error that prevents full extract of data from your Excel file.
    I am assuming you are executing script UpdatedPSData.bat
    Can you please:
    1. Make a copy of the file UpdatePSData.bat to UpdatePSData2.bat
    2. Edit file UpdatePSData2.bat. Replace last line:
    choice /C Y /T 10 /D Y /M "Waiting 10sec before closing"

    with line
    Pause

    3. Execute UpdatePSData2.bat. Somewhere it should show an error - you might need to scroll up. What is the error?

  • fsrobyfsroby
    *** Error. Please specify parameter value in psConfig.txt file

    In the UpdatePSData.bat file the lines for that entry are:


    C:\PortfolioSlicer\PortfolioSlicer-Source.xlsx


    which is indeed the name of the source file.
  • fsrobyfsroby
    Correction to the error message the < symbols excluded the name
    *** Error. Please specify "ExcelSourceFile" parameter value in psConfig.txt file

    In the UpdatePSData.bat file the lines for that entry are:


    C:\PortfolioSlicer\PortfolioSlicer-Source.xlsx


    which is indeed the name of the source file.
  • fsrobyfsroby
    I am running on Windows 11 24H2 and Excel for Microsoft 365 MSO (Version 2508 Build 16.0.19127.20192
  • fsrobyfsroby
    Okay. I did a clean install and copied in my source and reports files.
    Everything works fine now.
Sign In or Register to comment.