Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Portfolio Slicer 2.4 Quotes Not Updating Until Next Day
One day ago, I just started experiencing something odd in the quotes updates: the quotes now will not update to the current day until the next calendar day. All of the data appears to be accurately captured and everything looks good otherwise. I can certainly work with it but it means that I cannot get a portfolio update until the morning after. Has anyone else seen this behavior?
Comments
I have tried the latest script posted today. However, I still get the same results - no update for today. Based on the report when I run the script, it appears that the quotes requests succeeded but no new rows were written? The log for the Yahoo GetQuotes script is as follows:
19:42:05 --- Starting script GetQuotes-Yahoo.ps1
Symbol count: 25. MinDate: 2016-04-06
Symbol: TD.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_TD.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/TD.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: TD.TO. No new quotes found.
Symbol: NA.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_NA.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/NA.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: NA.TO. No new quotes found.
Symbol: GS.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_GS.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/GS.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: GS.TO. No new quotes found.
Symbol: CIX.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_CIX.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/CIX.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: CIX.TO. No new quotes found.
Symbol: FTS.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_FTS.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/FTS.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: FTS.TO. No new quotes found.
Symbol: TFII.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_TFII.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/TFII.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: TFII.TO. No new quotes found.
Symbol: ACQ.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_ACQ.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/ACQ.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: ACQ.TO. No new quotes found.
Symbol: MFC.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_MFC.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/MFC.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: MFC.TO. No new quotes found.
Symbol: XTC.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_XTC.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/XTC.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: XTC.TO. No new quotes found.
Symbol: BCE.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_BCE.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/BCE.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: BCE.TO. No new quotes found.
Symbol: HCG.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_HCG.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/HCG.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: HCG.TO. No new quotes found.
Symbol: RY.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_RY.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/RY.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: RY.TO. No new quotes found.
Symbol: T.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_T.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/T.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: T.TO. No new quotes found.
Symbol: ENF.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_ENF.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/ENF.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: ENF.TO. No new quotes found.
Symbol: SU.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_SU.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/SU.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: SU.TO. No new quotes found.
Symbol: LB.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_LB.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/LB.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: LB.TO. No new quotes found.
Symbol: AD.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_AD.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/AD.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: AD.TO. No new quotes found.
Symbol: CWB.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_CWB.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/CWB.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: CWB.TO. No new quotes found.
Symbol: MIC.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_MIC.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/MIC.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: MIC.TO. No new quotes found.
Symbol: CM.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_CM.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/CM.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: CM.TO. No new quotes found.
Symbol: TCL-A.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_TCL-A.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/TCL-A.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: TCL-A.TO. No new quotes found.
Symbol: SJR-B.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_SJR-B.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/SJR-B.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: SJR-B.TO. No new quotes found.
Symbol: BEP-UN.TO. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\_BEP-UN.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/BEP-UN.TO?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: BEP-UN.TO. No new quotes found.
Symbol: ^GSPC. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\__GSPC_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/^GSPC?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: ^GSPC. No new quotes found.
Symbol: ^GSPTSE. Next date: 2018-05-11. Quote file: C:\PS24\Quotes\__GSPTSE_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/^GSPTSE?period1=1525996800&period2=1526067727&interval=1d&events=history&crumb=HmYfHdhC1Y2
Done: ^GSPTSE. No new quotes found.
19:42:09 --- Finished. Quotes Requested/Succeed/Failed/Rows: 25/25/0/0. Duration: 5 sec.
OK..you were absolutely right. So I ran the batch file for intraday quotes and voila...I have the data for today. I am surprised because I never did this before and have been able to get today's quotes after market close.
Thank you for your help....