I have this error when I run the UpdatePSData script. This parameter is not listed in the psConfig file neither in the documentation.
Please let me know what do I have to configure and how.
Thanks in advanced for your help.
Below is the full output message.
Regards
Edgardo
16:51:45 Script: Yahoo Historical . Quotes Requested/Succeed/Failed/Rows: 3/3/0/6. Duration: 17 sec.
16:52:02 Script: Yahoo Intraday . Quotes Requested/Succeed/Failed/Rows: 3/3/0/3. Duration: 1 sec.
16:52:05 Script: ExchRate ECB . CurrExch Requested/Succeed/Failed/Rows: 2/2/0/4. Duration: 3 sec.
16:52:09 Script: ExchRate YahooID . CurrExch Requested/Succeed/Failed/Used: 2/2/0/0. Date: . Duration: 1 sec.
16:52:10 Script: Archive Quotes . Archived rec count: 6. Duration:
16:52:11 Script: MakeAllFiles Finished creating all data files. Duration: 1 sec.
16:52:12 Script: Create Dates . Dates: 3444. Duration: 0 sec.
16:52:13 Script: Append GenQ . GenQuotes SymbolCount/RecCount: 0/0. Duration: 0 sec.
*** Error. Please specify parameter value in psConfig.txt file
Import-CSV : Could not find file 'C:\PortfolioSlicer\PSData\TransactionsInExcel.csv'.
At C:\Portfolioslicer\Scripts\GetExcelCostBasis.ps1:13 char:6
+ $f = Import-CSV -Path $transFile -Delimiter `t | Sort Account,Symbol, ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
You cannot call a method on a null-valued expression.
At C:\Portfolioslicer\Scripts\GetExcelCostBasis.ps1:69 char:1
+ $fTxt = $fTxt.Substring(0, $fTxt.Length-$eol.Length); # Removing last ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
16:52:14 Script: CalcCostBasis . Duration: 0 sec.
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\Symbol.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:211 char:15
+ ... ymbolList = import-csv ($psDataFolder + "\Symbol.csv") -Delimiter $co ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
Symbol '* Cash' in Quotes.csv but not in Symbol.csv
Symbol 'FLGB' in Quotes.csv but not in Symbol.csv
Symbol '^GSPC' in Quotes.csv but not in Symbol.csv
Symbol '^GSPTSE' in Quotes.csv but not in Symbol.csv
Symbol '* Cash' in Dividends.csv but not in Symbol.csv
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\CompareTo.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:228 char:7
+ $sl = import-csv ($psDataFolder + "\CompareTo.csv") -Delimiter $colSe ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
Symbol '* Cash' in CompareTo.csv but not in Symbol.csv
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\SymbolAllocation.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:234 char:7
+ $sl = import-csv ($psDataFolder + "\SymbolAllocation.csv") -Delimiter ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
Symbol '* Cash' in SymbolAllocation.csv but not in Symbol.csv
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\SymbolSector.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:240 char:7
+ $sl = import-csv ($psDataFolder + "\SymbolSector.csv") -Delimiter $co ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
Symbol '* Cash' in SymbolSector.csv but not in Symbol.csv
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\TransType.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:256 char:18
+ ... sTypeList = import-csv ($psDataFolder + "\TransType.csv") -Delimiter ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\Allocation.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:266 char:19
+ ... ationList = import-csv ($psDataFolder + "\Allocation.csv") -Delimiter ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\SymbolAllocation.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:267 char:7
+ $al = import-csv ($psDataFolder + "\SymbolAllocation.csv") -Delimiter ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\ReportCurrency.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:276 char:17
+ ... rencyList = import-csv ($psDataFolder + "\ReportCurrency.csv") -Delim ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\Account.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:277 char:7
+ $cl = import-csv ($psDataFolder + "\Account.csv") -Delimiter $colSep ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\Symbol.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:283 char:7
+ $cl = import-csv ($psDataFolder + "\Symbol.csv") -Delimiter $colSep | ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
CurrencyFrom 'CAD' in CurrencyConv.csv but not in ReportCurrency.csv
CurrencyFrom 'USD' in CurrencyConv.csv but not in ReportCurrency.csv
CurrencyTo '' in CurrencyConv.csv but not in ReportCurrency.csv
CurrencyTo '' in CurrencyConv.csv but not in ReportCurrency.csv
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\Account.csv'.
At C:\Portfolioslicer\Scripts\psCheckFiles.ps1:306 char:16
+ ... countList = import-csv ($psDataFolder + "\Account.csv") -Delimiter $c ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundException
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportCsvCommand
Comments
But you have lots of different errors and not about Excel Source File location. So there might be something else.
Do you have folder: c:\PortfolioSlicer\PSData ?
For some reason the section was missing in the psconfig.txt file.