Yahoo free quotes - outage (hleofxquotes tool)
General discussion
All replies
-
I made some progress on getting the trade date and time values for Yahoo2 quote source. The next build will include
- Trade date and time values
- An indicator in the price column to show
- (O) means price is from an exchange that is still OPEN
- (C) means price is from an exchange that has CLOSED
I will try to find time to do a new build this week-end.
A preview:
-
Hi Jacquouille,
I did a quick test and it shows that Money imported in as 11/15.
First screen shot is the price/date as retrieved.
Second screen shot is the price/date as imported into Money.
Can you send me an email at hleofxquotes gmail com. I'd like to gather additional information such as your money version, your location (timezone info ...)
-
Hi Jacquouille,I think I know what is causing the date for FR0000018954.PA to show up as 11/17 instead of the expected 11/15. It appears that Money is NOT using the investment specific DTPRICEASOF (Per OFX spec: Date and time of unit price and market value. If this date is unknown, use 19900101 as the placeholder; do not use 0, datetime). Instead Money using the value of INVSTMTRS.DTASOF (Per spec: As of date & time for the statement download, datetime)
Since there is only ONE INVSTMTRS.DTASOF, if you have multiple quotes coming from multiple exchanges (some from US, some from Europe), the value of INVSTMTRS.DTASOF will have the date of the latest trade date among all the quotes. In your case, I am guessing you have some US quotes and therefore, the value of 11/17 is from one of the US quotes.
Will look for a work-around.
Jacquouille la Fripouiile
I reply to you late. I'm sorry.
I don't understand all what you tell me because I am not an expert of OFX files. And I dont find how to get the second picture you showed. I just say that I live in France and all my stocks are price on Paris Stock Exchange.
My old Money version is 13 years old (2004). The least one was 2005's but did not change anything.
The problem about the french mutual funds is that the assets managers publish their price one or 2 days later.Then the text of quote.ofx :
<?xml version="1.0" encoding="UTF-8"?>
<?OFX OFXHEADER="200" VERSION="200" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>
<OFX>
<!--Created by hleOfxQuotes on: Thu Nov 30 23:30:59 CET 2017-->
<SIGNONMSGSRSV1>
<SONRS>
<!--DTSERVER local time is 20171130233059-->
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
<MESSAGE>Successful Sign On</MESSAGE>
</STATUS>
<DTSERVER>20171130223059</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
</SONRS>
</SIGNONMSGSRSV1>
<INVSTMTMSGSRSV1>
<INVSTMTTRNRS>
<TRNUID>76561E32-C879-415D-8B7B-90AC88F6B4F5</TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<!--DTASOF local time is 20171127210000-->
<INVSTMTRS>
<DTASOF>20171127200000</DTASOF>
<CURDEF>EUR</CURDEF>
<INVACCTFROM>
<BROKERID>hungle.com</BROKERID>
<ACCTID>0123456789</ACCTID>
</INVACCTFROM>
<!--work-around for MM2005UK to set the download statement date-->
<INVTRANLIST>
<DTSTART>20171127200000</DTSTART>
<DTEND>20171127200000</DTEND>
</INVTRANLIST>
<INVPOSLIST>
<POSMF>
<!--DTPRICEASOF local time is Mon Nov 27 21:00:00 CET 2017-->
<!--DTPRICEASOF GMT time is 20171127200000-->
<INVPOS>
<!--Ticker from quote source is: FR0000018954.PA-->
<SECID>
<UNIQUEID>FR0000018954.PA</UNIQUEID>
<UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE>
</SECID>
<HELDINACCT>OTHER</HELDINACCT>
<POSTYPE>LONG</POSTYPE>
<UNITS>0,414</UNITS>
<UNITPRICE>163,18</UNITPRICE>
<MKTVAL>67,55652</MKTVAL>
<DTPRICEASOF>20171127200000</DTPRICEASOF>
<CURRENCY>
<CURRATE>1.00</CURRATE>
<CURSYM>EUR</CURSYM>
</CURRENCY>
<MEMO>Price as of date based on closing price</MEMO>
</INVPOS>
<REINVDIV>Y</REINVDIV>
<REINVCG>Y</REINVCG>
</POSMF>
</INVPOSLIST>
</INVSTMTRS>
</INVSTMTTRNRS>
</INVSTMTMSGSRSV1>
<SECLISTMSGSRSV1>
<SECLIST>
<MFINFO>
<!--Ticker from quote source is: FR0000018954.PA-->
<!--DTASOF local time is Mon Nov 27 21:00:00 CET 2017-->
<!--Security is treated as Mutual Fund-->
<SECINFO>
<SECID>
<UNIQUEID>FR0000018954.PA</UNIQUEID>
<UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE>
</SECID>
<SECNAME>LCL Actions Euro D</SECNAME>
<TICKER>FR0000018954.PA</TICKER>
<UNITPRICE>163,18</UNITPRICE>
<DTASOF>20171127200000</DTASOF>
<CURRENCY>
<CURRATE>1.00</CURRATE>
<CURSYM>EUR</CURSYM>
</CURRENCY>
<MEMO>Price as of date based on closing price</MEMO>
</SECINFO>
<MFTYPE>OPENEND</MFTYPE>
</MFINFO>
</SECLIST>
</SECLISTMSGSRSV1>
</OFX>Thanks for your help.
- Edited by Jacquouille la Fripouille Thursday, November 30, 2017 10:40 PM
-
Ho, it looks fine to-night. (The previous prices "Actualiser" were loaded by hand)
Jacquouille la Fripouiile
- Edited by Jacquouille la Fripouille Thursday, November 30, 2017 11:21 PM
