Can you please take a screenshot of your c:\PortfolioSlicer\PSData folder. I want to see all files in that folder. And second screenshot - open Transactions.csv and show first few lines.
Here is some information for you: 1. Portfolio Slicer will not work if your computer/laptop does not have internet connection. Yes, you can copy files between different machines, but you need to know what you are doing and need to be consistent with what you copy over. 2. Your Transactions.csv file looks OK. 3. In your c:\PortfolioSlicer\PSData folder file Dates.csv was created 17min before all other files. That would not happens during normal PortfolioSlicer file preparations and I cannot explain why you have this. 4. In your c:\PortfolioSlicer\PSData folder you are missing file schema.ini. This is most likely why you are having errors while refreshing Portfolio Slicer report workbook. I cannot explain why this file is missing on your computer.
1. I was hoping maybe i can input data of assets manually, as my countries stock market isn't updated on google finance or Yahoo finance.
3. I created this dates.csv using script by maxim separately and others are from extract data from excel bat file.
4. I forgot to create psdatafile. I did now. But now symbol cant be found in the rowest error .
This is the error.txt
Wednesday, April 8, 2026 6:23:51 AM
PS data folder changed to c:\PortfolioSlicer\PSData\
=======================================================================================
06:23:51 --- Starting script CheckPSFiles.ps1
06:23:51 File Dates.csv. Record count: 4118
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dates.csv. Maximum date in file should be today - OK (2026-04-08)
Dates.csv. Dates should be unique - OK
06:23:52 File Dates.csv check completed. No issues found.
06:23:52 File Quotes.csv. Record count: 0
Quotes.csv. Row count - must be at least 2 (header and at least one record) - ERROR
Quotes.csv. First row (file header) should be 'Date Close Symbol' - ERROR. Actual value: ''
Quotes.csv. Each row should have exactly two column separators (' ') - OK
06:23:52 File Quotes.csv check completed. Errors found - please review
06:23:52 File Dividends.csv. Record count: 0
Dividends.csv. Row count - must be at least 1 (header) - ERROR
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - ERROR. Actual value: ''
Dividends.csv. Each row should have exactly two column separators (' ') - OK
06:23:52 File Dividends.csv check completed. Errors found - please review
06:23:52 File CurrencyConv.csv. Record count: 0
CurrencyConv.csv. Row count - must be at least 1 (header) - ERROR
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - ERROR. Actual value: ''
CurrencyConv.csv. Each row should have exactly three column separators (' ') - OK
06:23:52 File CurrencyConv.csv check completed. Errors found - please review
06:23:52 --- Finished. Duration: 0 sec.
=======================================================================================
Ohh , finally it worked after running UpdatePSData.bat .. I am such a stupid I was using only the updatepsdatafromexcel. But i think that one has some issue. So it did refresh now without any issue. I will check if i can fix my one now(as its the demo). Its been so many days you have replied and guided to help me without making this paid . Respect from my heart for you Vidas. Thanks a lot for bearing with my stupidity and also making such a great tool open for free.
Comments
1. Portfolio Slicer will not work if your computer/laptop does not have internet connection. Yes, you can copy files between different machines, but you need to know what you are doing and need to be consistent with what you copy over.
2. Your Transactions.csv file looks OK.
3. In your c:\PortfolioSlicer\PSData folder file Dates.csv was created 17min before all other files. That would not happens during normal PortfolioSlicer file preparations and I cannot explain why you have this.
4. In your c:\PortfolioSlicer\PSData folder you are missing file schema.ini. This is most likely why you are having errors while refreshing Portfolio Slicer report workbook. I cannot explain why this file is missing on your computer.
I would encourage you to:
1. Read this guide: https://www.portfolioslicer.com/data/data-faq.html#faq-refresh-error
2. Try first investigating issues using AI Help: https://chatgpt.com/g/g-69c5a83d64208191aab7f08198c38658-portfolio-slicer-official-assistant
3. I created this dates.csv using script by maxim separately and others are from extract data from excel bat file.
4. I forgot to create psdatafile. I did now. But now symbol cant be found in the rowest error .
This is the error.txt
Wednesday, April 8, 2026 6:23:51 AM
PS data folder changed to c:\PortfolioSlicer\PSData\
=======================================================================================
06:23:51 --- Starting script CheckPSFiles.ps1
06:23:51 File Dates.csv. Record count: 4118
Dates.csv. Row count - must be at least 2 (header and at least one date) - OK
Dates.csv. First row (file header) should be 'Date' - OK
Dates.csv. All but first row (header) should be in format YYYY-MM-DD - OK
Dates.csv. Minimum date in file should be configured MinDate - OK (2014-12-31)
Dates.csv. Maximum date in file should be today - OK (2026-04-08)
Dates.csv. Dates should be unique - OK
06:23:52 File Dates.csv check completed. No issues found.
06:23:52 File Quotes.csv. Record count: 0
Quotes.csv. Row count - must be at least 2 (header and at least one record) - ERROR
Quotes.csv. First row (file header) should be 'Date Close Symbol' - ERROR. Actual value: ''
Quotes.csv. Each row should have exactly two column separators (' ') - OK
06:23:52 File Quotes.csv check completed. Errors found - please review
06:23:52 File Dividends.csv. Record count: 0
Dividends.csv. Row count - must be at least 1 (header) - ERROR
Dividends.csv. First row (header) should be 'PayDate DividendPerShare Symbol' - ERROR. Actual value: ''
Dividends.csv. Each row should have exactly two column separators (' ') - OK
06:23:52 File Dividends.csv check completed. Errors found - please review
06:23:52 File CurrencyConv.csv. Record count: 0
CurrencyConv.csv. Row count - must be at least 1 (header) - ERROR
CurrencyConv.csv. First row should be 'Date ExchRate CurrencyFrom CurrencyTo' - ERROR. Actual value: ''
CurrencyConv.csv. Each row should have exactly three column separators (' ') - OK
06:23:52 File CurrencyConv.csv check completed. Errors found - please review
06:23:52 --- Finished. Duration: 0 sec.
=======================================================================================
Cant i use it offline?