Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Quotes not downloading

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 *****
Sign In or Register to comment.