Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
NEW FUNCTIONALITY - Now you can refresh your Excel reports by running .bat file
Hello,
I just updated the download scripts that now include the following new functionality.
- Each PowerShell .ps1 script now has its own version. This change will not have any impact on you now, but because of this, you will need to update all of your .ps1 scripts. This change will allow better handling of script changes in the future.
- There is a new PowerShell script, RefreshPSExcelReports.ps1. Every single line of this script was written by ChatGPT. This script refreshes Portfolio Slicer Excel reports. With this script, you now have an option to refresh your Excel workbook from .bat file.
- I added new .bat files: RefreshPSExcelReport.bat and RefreshPSExcelReport-Lite.bat that run Excel refresh scripts.
- In other older .bat files, at the end, I added a line to refresh Excel reports, but that line was commented out (starts with REM ). If you remove REM, your Excel workbook refresh will be done at the same time as you update your quotes/exchange rates.
- If you use Task Scheduler to update your quotes, you can now include refreshing your Excel workbook at the same time. You can read more on how to schedule a refresh here: https://www.portfolioslicer.com/scripts/schedule-data-update.html. Keep in mind that if the scheduled refresh includes an Excel workbook refresh, the configuration is slightly different (bold on that page).
In my own configuration, all quotes, exchange rates, and Excel workbooks are now refreshed through Task Scheduler. As my Portfolio Slicer report workbook is stored on Dropbox, I can now open that workbook from my phone, and it will have my investment information as of the last refresh time. That is very convenient.
I just updated the download scripts that now include the following new functionality.
- Each PowerShell .ps1 script now has its own version. This change will not have any impact on you now, but because of this, you will need to update all of your .ps1 scripts. This change will allow better handling of script changes in the future.
- There is a new PowerShell script, RefreshPSExcelReports.ps1. Every single line of this script was written by ChatGPT. This script refreshes Portfolio Slicer Excel reports. With this script, you now have an option to refresh your Excel workbook from .bat file.
- I added new .bat files: RefreshPSExcelReport.bat and RefreshPSExcelReport-Lite.bat that run Excel refresh scripts.
- In other older .bat files, at the end, I added a line to refresh Excel reports, but that line was commented out (starts with REM ). If you remove REM, your Excel workbook refresh will be done at the same time as you update your quotes/exchange rates.
- If you use Task Scheduler to update your quotes, you can now include refreshing your Excel workbook at the same time. You can read more on how to schedule a refresh here: https://www.portfolioslicer.com/scripts/schedule-data-update.html. Keep in mind that if the scheduled refresh includes an Excel workbook refresh, the configuration is slightly different (bold on that page).
In my own configuration, all quotes, exchange rates, and Excel workbooks are now refreshed through Task Scheduler. As my Portfolio Slicer report workbook is stored on Dropbox, I can now open that workbook from my phone, and it will have my investment information as of the last refresh time. That is very convenient.
Comments
Command is:
Parameter ".\Scripts\RefreshPSExcelReport..." means from the current folder go to Scripts subfolder and run script RefreshPSExcelReport
So please confirm that in the c:\PortfolioSlicer\PSDataExtract\Scripts folder you have a script RefreshPSExcelReport
Just you will have to edit .bat file to point to your Excel workbook.