Script having problems

rpaldrich

Hello -- I'm having an issue that pops up when I run UpdatePSData.bat.
It says it cannot find "TransactionsInExcel.csv", and "Symbol.csv".
Where do these csv files come from?


I do not see these files in the PSdata (I call it PSdataNEW) folder. Any idea? Partial error log below and attached.

Error log from PSData file;
Symbol '* Cash' in Quotes.csv but not in Symbol.csv
Symbol 'AMZN' in Quotes.csv but not in Symbol.csv
Symbol 'BND' in Quotes.csv but not in Symbol.csv
....

VidasMatelis

Error is "Please specify ExcelSource parameter in psConfig.txt.

If you are using old (v2.x) psConfig.txt, then add following lines to your psConfig.txt, but change your actual file location:

<ExcelSourceFile>
C:\MyFolder\Dropbox\PortfolioSlicer\PortfolioSlicer-Source.xlsx
</ExcelSourceFile>

rpaldrich

Vidas -- Thank you Sir! This was something I overlooked.
FWIW, I am using the most recent version and the yahoo script that comes w/ Ver 3.1 does not work. I copied the three yahoo based scripts from the DDM V3 download in place of what came with Ver 3.1 and now it is working, unsure what is causing the failure.

I'll now copy over all my data and see what happens. Fingers crossed.

Mat

I bought a new computer and Portfolio Slicer does not work anymore.
When I clicked on "UpdatePSData", I got this error message:


C:\PortfolioSlicer\Scripts>echo off
Invoke-WebRequest : if(window!=window.top){document.write('

Content is currently
unavailable.

');}else{window.location.replace('https://www.yahoo.com/?err=404&err_url=http
s%3A%2F%2Fbrb.yahoo.net%3A443%2Ffinance.yahoo.com%2Fdesktop%2Fquote%2FAAPL%2Fhistory%2Findex.html');}
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:20 char:17
+ ... $wrCookie = Invoke-WebRequest -Uri $urlCookie -SessionVariable webses ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebExc
eption
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand
You cannot call a method on a null-valued expression.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:22 char:5
+ $crumbStart = $webCookie.IndexOf($crumbStr); if ($crumbStart -eq ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:23 char:5
+ $crumb = $webCookie.Substring($crumbStart+$crumbStr.Length,100); ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero.
Parameter name: length"
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:25 char:5
+ $crumb = $crumb.Substring(0, $crumbEnd); # ================ At ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : ArgumentOutOfRangeException

Invoke-WebRequest : The remote server returned an error: (404) Not Found.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:20 char:17
+ ... $wrCookie = Invoke-WebRequest -Uri $urlCookie -SessionVariable webses ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebExc
eption
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand

You cannot call a method on a null-valued expression.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:22 char:5
+ $crumbStart = $webCookie.IndexOf($crumbStr); if ($crumbStart -eq ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:23 char:5
+ $crumb = $webCookie.Substring($crumbStart+$crumbStr.Length,100); ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero.
Parameter name: length"
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:25 char:5
+ $crumb = $crumb.Substring(0, $crumbEnd); # ================ At ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : ArgumentOutOfRangeException

Invoke-WebRequest : if(window!=window.top){document.write('

Content is currently
unavailable.

');}else{window.location.replace('https://www.yahoo.com/?err=404&err_url=http
s%3A%2F%2Fbrb.yahoo.net%3A443%2Ffinance.yahoo.com%2Fdesktop%2Fquote%2FAAPL%2Fhistory%2Findex.html');}
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:20 char:17
+ ... $wrCookie = Invoke-WebRequest -Uri $urlCookie -SessionVariable webses ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebExc
eption
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand
You cannot call a method on a null-valued expression.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:22 char:5
+ $crumbStart = $webCookie.IndexOf($crumbStr); if ($crumbStart -eq ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:23 char:5
+ $crumb = $webCookie.Substring($crumbStart+$crumbStr.Length,100); ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero.
Parameter name: length"
At C:\PortfolioSlicer\Scripts\Scripts\GetQuotes-Yahoo.ps1:25 char:5
+ $crumb = $crumb.Substring(0, $crumbEnd); # ================ At ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : ArgumentOutOfRangeException

22:25:01 Script: Yahoo Historical . Quotes Requested/Succeed/Failed/Rows: 155/0/155/0. Duration: 14 sec.
22:25:16 Script: Yahoo Intraday . Quotes Requested/Received/Used : 155/0/0. Quote time: . Duration: 0 sec.
22:25:21 Script: ExchRate Stooq . CurrExch Requested/Succeed/Failed/Rows: 2/0/2/0. Duration: 2 sec.
22:25:25 Script: Archive Quotes . Archived rec count: 0. Duration:
22:25:29 Script: Create Dates . Dates: 3610. Duration: 0 sec.
22:25:30 Script: Append GenQ . GenQuotes SymbolCount/RecCount: 0/0. Duration: 0 sec.
22:25:31 Script: CheckFiles . Duration: 1 sec.
***** Generated PS files were checked - no issues found *****

Trenzalore

Mat,

I think that you are using an old GetQuotes-Yahoo.ps1 script file.

Go to the Downloads page and get an updated file from the link in the "Download Scripts to extract and manage external data" section. Then replace the GetQuotes-Yahoo.ps1 file that you have with the new one and try again.

VidasMatelis

@Trenzalore right - after downloading ALL scripts, you also need to download updated external management scripts and that should fix the errors you have.