Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Error with update
I downloaded the new scripts last week and have a new error that appears during the batch update. I'm not sure what this means, but I am seeing that my excel/pivot tables don't update to today's date. As of today, the Daily tab only shows up to Dec 8 even though the CSV and Quote files have up to today's date Dec 12. I think it might have to do with the following error. Do you happen to know what the resolution to this error is?
Thank you
22:32:26 Script: Google Historical . Quotes Requested/Succeed/Failed/Rows: 4/0/4/0. Duration: 1 sec.
Exception calling "ParseExact" with "3" argument(s): "The DateTime represented by the string is not supported in calendar
System.Globalization.GregorianCalendar."
At C:\PSdata\Scripts\psFunctions.ps1:13 char:5
+ $symbolMaxDateAdj = ([datetime]::ParseExact($symbolMaxDate,"yyyy- ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : FormatException
22:32:28 Script: GoogleWeb Hist . Quotes Requested/Succeed/Failed/Rows: 25/9/16/0. Duration: 7 sec.
22:32:38 Script: Google Intraday . Quotes Requested/Succeed/Failed/Rows: 20/16/4/1. Duration: 9 sec.
22:32:49 Script: ExchRate Stooq . CurrExch Requested/Succeed/Failed/Rows: 2/0/2/0. Duration: 1 sec.
22:32:51 Script: ExchRate GoogleID . CurrExch Requested/Succeed/Failed: 0/0/2. Date: . Duration: 1 sec.
22:32:54 Script: Archive Quotes . Archived rec count: 0. Duration:
22:32:56 Script: MakeAllFiles Finished creating all data files. Duration: 6 sec.
22:33:03 Script: Create Dates . Dates: 3665. Duration: 0 sec.
22:33:05 Script: Append GenQ . GenQuotes SymbolCount/RecCount: 0/0. Duration: 0 sec.
22:33:06 Script: CheckFiles . Duration: 2 sec.
***** Generated PS files were checked - no issues found *****
Thank you
22:32:26 Script: Google Historical . Quotes Requested/Succeed/Failed/Rows: 4/0/4/0. Duration: 1 sec.
Exception calling "ParseExact" with "3" argument(s): "The DateTime represented by the string is not supported in calendar
System.Globalization.GregorianCalendar."
At C:\PSdata\Scripts\psFunctions.ps1:13 char:5
+ $symbolMaxDateAdj = ([datetime]::ParseExact($symbolMaxDate,"yyyy- ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : FormatException
22:32:28 Script: GoogleWeb Hist . Quotes Requested/Succeed/Failed/Rows: 25/9/16/0. Duration: 7 sec.
22:32:38 Script: Google Intraday . Quotes Requested/Succeed/Failed/Rows: 20/16/4/1. Duration: 9 sec.
22:32:49 Script: ExchRate Stooq . CurrExch Requested/Succeed/Failed/Rows: 2/0/2/0. Duration: 1 sec.
22:32:51 Script: ExchRate GoogleID . CurrExch Requested/Succeed/Failed: 0/0/2. Date: . Duration: 1 sec.
22:32:54 Script: Archive Quotes . Archived rec count: 0. Duration:
22:32:56 Script: MakeAllFiles Finished creating all data files. Duration: 6 sec.
22:33:03 Script: Create Dates . Dates: 3665. Duration: 0 sec.
22:33:05 Script: Append GenQ . GenQuotes SymbolCount/RecCount: 0/0. Duration: 0 sec.
22:33:06 Script: CheckFiles . Duration: 2 sec.
***** Generated PS files were checked - no issues found *****
Comments
Example for properly defined symbol:
RWO,2014-05-01,,Y,N,,,
or
RWO
or
RWO,2014-05-01,2015-01-01
Your issue most likely in 3rd place, example:
RWO,2014-05-01,2015-Nov-01
For example:
INDEXTSI:OSPTX
NYSE:BAC,2012-04-01
NYSE:GLW,2012-09-01
TSE:BMO,2010-12-31,2015-09-31
TSE:VAB,2016-10-01
Also, when you send me data, can you please include "Control Pannel"-"Region" information.
My email is published: http://www.portfolioslicer.com/contact.html
Thanks for sending me your psConfig.txt file. One of your dates in psConfig.txt file for SymbolMaxDate is set to 2015-09-31, but september can have maximum 30 days. So please change that date to 2015-09-30 and rerun scripts.