Help please. I noted the error messages below and my quotes are not updating. What happened?
I attached the log in Word.
Below are the excerpt, as the full file is too long to post:
C:\PortfolioSlicer\Scripts>echo off
07:37:58 Script: Yahoo Historical . Quotes Requested/Succeed/Failed/Rows: 2/2/0/0. Duration: 1 sec.
07:37:59 Script: Yahoo Intraday . Quotes Requested/Succeed/Failed/Rows: 2/2/0/2. Duration: 0 sec.
07:38:03 Script: ExchRate ECB . CurrExch Requested/Succeed/Failed/Rows: 2/2/0/0. Duration: 4 sec.
07:38:09 Script: ExchRate YahooID . CurrExch Requested/Succeed/Failed/Used: 2/2/0/2. Date: . Duration: 1 sec.
07:38:11 Script: Archive Quotes . Archived rec count: 0. Duration:
07:38:13 Script: MakeAllFiles Finished creating all data files. Duration: 2 sec.
07:38:16 Script: Create Dates . Dates: 4272. Duration: 0 sec.
07:38:18 Script: Append GenQ . GenQuotes SymbolCount/RecCount: 0/0. Duration: 1 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\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\Scripts\GetExcelCostBasis.ps1:69 char:1
+ $fTxt = $fTxt.Substring(0, $fTxt.Length-$eol.Length); # Removing last ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull
07:38:21 Script: CalcCostBasis . Duration: 0 sec.
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\Symbol.csv'.
At C:\PortfolioSlicer\Scripts\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 'ACWV' in Quotes.csv but not in Symbol.csv
Symbol 'AGG' in Quotes.csv but not in Symbol.csv
import-csv : Could not find file 'C:\PortfolioSlicer\PSData\CompareTo.csv'.
At C:\PortfolioSlicer\Scripts\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\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\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\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\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\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\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\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\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\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
07:38:23 Script: CheckFiles . Duration: 4 sec.
***** Generated PS files were checked - errors were found, please review *****