Howdy, Stranger!

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

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 *****

Comments

  • Could you please double check your psConfig.txt file information about each symbol for Google and GoogleWeb sections, specifically SymbolMaxDate values. They all MUST BE IN FORMAT YYYY-MM-DD or there should be no value.
    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

  • Vidas, this is so strange. I checked my file and the dates are properly defined as you say.

    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

  • Can you send me your psConfig.txt?
    Also, when you send me data, can you please include "Control Pannel"-"Region" information.
    My email is published: http://www.portfolioslicer.com/contact.html
  • Hi,

    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.

  • Vidas, that solved the error message. For the excel update problem I was having, I started with the new excel file and reloaded all the transactions and stuff in the other tabs and it's working nicely again. Thank you for helping me! Great work
Sign In or Register to comment.