none
Yahoo free quotes - outage (hleofxquotes tool) RRS feed

  • General discussion

  • Look like the Yahoo free quotes service is not working. This will affect the hleofxquotes tool. Hopefully, this is just temp outage. But just in case, I will start to look for alternate quote source.

    Best,

    Thursday, November 2, 2017 9:13 PM

All replies

  • Look like the Yahoo free quotes service is not working. This will affect the hleofxquotes tool. Hopefully, this is just temp outage. But just in case, I will start to look for alternate quote source.

    Thanks for the update.  This is still my backup when Gaier misses some quotes so I hope its back soon!
    Thursday, November 2, 2017 9:59 PM
  • My guess is that the Yahoo CSV quotes API has gone for good judging by this message now returned by the URL: "It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com."

    Yahoo do - at least for the moment - provide a JSON quotes API, see here: https://github.com/pilwon/node-yahoo-finance/issues/43.

    Thursday, November 2, 2017 10:38 PM
  • My guess is that the Yahoo CSV quotes API has gone for good judging by this message now returned by the URL: "It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com."

    Indeed and OUCH!  http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT+FOO.BAR

    • Edited by john.b_ Thursday, November 2, 2017 11:12 PM
    Thursday, November 2, 2017 11:11 PM
  • For the adventurous, see: https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/README-Build_20171102_120.txt

    Please read the README. The new jar file mentioned in the README is at

    https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/hleOfxQuotes-Build_20171102_120-app.jar

    Click on 'raw' button to download the actual jar file. Your browser might warn that this file type is dangerous (it does that for all file with suffix .jar). Alternative, if you have git, you can just clone the repo

    git clone https://github.com/hleofxquotes/hleofxquotes.git



    Thursday, November 2, 2017 11:50 PM
  • For the adventurous, see: https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/README-Build_20171102_120.txt

    Please read the README. The new jar file mentioned in the README is at

    https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/hleOfxQuotes-Build_20171102_120-app.jar


    Thank you very much!  Working again - for now
    Friday, November 3, 2017 8:14 AM
  • The new 2017 jar file walks. If the time of downloading is a little longer, the principal difference I see is that the date and the time of the last quotation don't appear.
    My 22 stocks are treated in the same time.

    Jacquouille la Fripouiile

    Friday, November 3, 2017 2:00 PM
  • Thanks --  need to read the notes -- stock symbols go into Yahoo2..   Works fine...   Appreciate the update.
    • Edited by radarman123 Friday, November 3, 2017 5:42 PM
    Friday, November 3, 2017 5:34 PM
  • You are importing all Mutual Funds as if they were stocks (POSSTOCK instead of POSMF, STOCKINFO instead of MFINFO). This makes Money think that there are new stocks to be matched to the ticker, and since they are reported as stocks, Money will not allow you to match to the existing mutual funds. This is preventing me from updating any mutual funds in my portfolio.

    You need to fix this as soon as possible.


    Bob - MSN Mobile

    P.S. My workaround for this right now is to keep two lists of my tickers. One has my stocks, and that can be directly imported into Money. The second list contains only my mutual funds. I save that as an OFX download. I then open the OFX file in notepad and do a global change of STOCK to MF (case sensitive). I can then double-click the OFX file and it will import with no issues.

    I have to do two separate quote searches and manually modify the output of the second search, but it will work.

    • Edited by BobSmiley Saturday, November 4, 2017 2:32 AM
    Saturday, November 4, 2017 2:09 AM
  • Bob, you are right. Will fix. I did a cursory test using a brand new money file with no existing data so I did not catch it.

    Folks, hold off on Build_20171102_120. Will come up with another build this week-end.

    Saturday, November 4, 2017 3:59 AM
  • Will come up with another build this week-end.

    Thanks so much for your time with this.  We appreciate it!

    Could you also default to Yahoo2 tab on opening?


    Also, I typically download MF quotes in the morning for the prior trading day.  Since the Yahoo2 source doesn't provide last trade date, DTASOF is set to current date.  Therefore, I use the Date Offset of -1 to insure it imports with the correct trade date in my scenario.  This is not an issue but do you know if trade dates are possible with the new source?
    • Edited by john.b_ Saturday, November 4, 2017 8:44 AM
    Saturday, November 4, 2017 8:33 AM
  • New build:  https://github.com/hleofxquotes/hleofxquotes/tree/master/dist (see README file)

    default to Yahoo2 tab on opening

    The new build will remember the last tab used and open to it on next start up

    > Trade date/time

    I've looked, but Yahoo2 does not have the last trade date/time.

    So for now I've default to time at quote fetch. As pointed out by john.b, that could cause wrong value for DTASOF. Use 'Date Offset' is a good work-around. If someone has suggestion on better default, I am all ear.

    Also, in new build, I've enable  multi-thread fetch so if you have a large list of symbols, you will see some speed up.

    As noted in README, these changes have little testing but I am using this tool daily so I am motivated to fix issue as they come up.

    Best,


    Saturday, November 4, 2017 9:08 AM
  • New build:  https://github.com/hleofxquotes/hleofxquotes/tree/master/dist (see README file)


    Thanks for the quick turnaround!  Works fine.

    FYI - I believe your commit of the new build has title referring to old build.  Shouldn't it be "Add build Build_20171104_123"

    Saturday, November 4, 2017 10:24 AM
  • Much improved. Works very well. Thanks for the quick updates.


    Bob - MSN Mobile

    Saturday, November 4, 2017 6:41 PM
  • Fund Manager portfolio software also uses the Yahoo quote server as default for downloads. It seems that Yahoo has changed their interface and are no longer supporting old configurations. Here is the link to information regarding their discussions with Yahoo:

    fundmanagersoftware.com/forum/viewtopic.php?f=2&t=4481

    Here are excerpts from the above link:

    Per Mark from Fund Manager:

    UPDATE 2: This same Yahoo representative is now saying that the interface being used by Fund Manager to get quotes is going to be discontinued. We are looking into alternatives, and will likely be publishing an updated quote module.

    UPDATE 3: Yahoo has announced they are discontinuing the interface previously used by Fund Manager. Therefore, we have released a new quote module (522) to address this problem. This update fixes all the previously broken Yahoo servers. Unfortunately these fixed Yahoo servers are significantly slower than before. If you have many quotes to retrieve you may consider looking at other quote servers.




    • Edited by johngilford Saturday, November 4, 2017 9:42 PM
    Saturday, November 4, 2017 8:39 PM
  • Thanks very much. Spent a day or two before I decided it was not an issue in my config.

    Found this thread and it is working again.  Cannot thank you enough for continuing to keep this running.

    Regards, Tim


    Thanks, Tim

    Sunday, November 5, 2017 4:32 AM
  • Cela fonctionne parfaitement !!!

    Merci beaucoup pour le maintien à jour de cette application géniale !

    Sunday, November 5, 2017 11:43 AM
  • Nice work!

    I have used your quotes tool for several years and found it to be invaluable when MS dropped support for Money.

    Thanks for your efforts on this.

    Sunday, November 5, 2017 3:02 PM
  • Still can request portfolio to be downloaded but their are difference in file format:


    File download difference by Yahoo are:


    ,2017/11/01,16:00EDT, which is done by request
    ,”11/1/2017”,”4:00 PM”,which is done automatically by url


    USDJPY=X,USDCHF=X, and USDCAD=X  show quotes in my portfolio but will not
    download by request until changed to JPY=X, CHF=X and  CAD=X.

    Monday, November 6, 2017 3:02 AM
  • Thanks so much for keeping this working !!

    I get this Java exception when I try to start the latest version -- any ideas?

    > java -jar hleOfxQuotes-Build-20171104_123-app.jar

    Exception in thread "main" java.lang.UnsupportedClassVersionError: app/GUI : Unsupported major.minor version 52.0
       at java.lang.ClassLoader.defineClass1 (Native Method)
       ....

    I'm on Windows XP, and Java version is 1.7.0_25

    Thanks!!

    Tuesday, November 7, 2017 6:23 PM
  • [Sorry for double post -- previous one appeared lost in middle of thread]

    Thank you for keeping this working !!

    I get this Java exception when I try to start the latest version -- any ideas?

    > java -jar hleOfxQuotes-Build-20171104_123-app.jar

    Exception in thread "main" java.lang.UnsupportedClassVersionError: app/GUI : Unsupported major.minor version 52.0
       at java.lang.ClassLoader.defineClass1 (Native Method)
       ....

    I'm on Windows XP, and Java version is 1.7.0_25

    Thanks!!

    Tuesday, November 7, 2017 6:24 PM
  • I'm on Windows XP, and Java version is 1.7.0_25
    Update to version 1.8 of Java
    Tuesday, November 7, 2017 10:34 PM
  • 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:

    Saturday, November 11, 2017 7:34 AM
  • Thank you very much for your work.

    We wait for the result next monday.


    Jacquouille la Fripouiile

    Saturday, November 11, 2017 11:18 AM
    • New build hleOfxQuotes-Build_20171110_131
    • Please see README file in: https://github.com/hleofxquotes/hleofxquotes/tree/master/dist
    • Fixes:

        * For Yahoo2, add Trade Date and Time values.

        * Show mapper at load time. Previously, the mapper window is only updated after the prices are updated.

        * Add an indicator in the Price column

          ** (O) means price is from an exchange that is still OPEN
          ** (C) means price is from an exchange that has CLOSED 

    Saturday, November 11, 2017 11:40 PM
    • New build hleOfxQuotes-Build_20171110_131

    Looks like this should work well except Date Offset may still need to be used.  DTASOF (under INVSTMTRS) is taking its date from the DTASOF of the most recently traded security but in GMT instead of local time.

    Before the recent Yahoo change, local time was used to set DTASOF so Date Offset could stay at zero.  Is it intentional to now require the use of Date Offset?

    Sunday, November 12, 2017 3:09 PM
  • Thanks a lot for posting this link. That and https://github.com/VBA-tools/VBA-JSON look like the kernel to (yet another) re-factoring of my Access-VBA Quote Fetcher.

    I wonder how long Verizon will keep these APIs before they, too, go 999.

    Sunday, November 12, 2017 4:26 PM
    Moderator
  • Hi John,

    I believe the value for INVSTMTRS.DTASOF has always been in GMT and is the max trade/time of all the securities. Previously, since the trade/time not available, I just use current time. This is my recollection anyway. If you think that is not the case, please let me know and I will take a closer look at the code changes.

    A quick summary of how date/time related values are being currently generated in the OFX file

    For all time values, I use YYYYmmDDHHMMSS (20171112164216) format with no timezone. Per OFX spec, no timezone means GMT time.

    DTSERVER: current time (in GMT)

    INVSTMTRS.DTASOF: the max trade date/time of all the security (in GMT)

    INVPOS.DTPRICEASOF: date/time provided by quote source (in GMT)

    STOCKINFO.DTASOF: date/time provided by quote source (in GMT)

    If you have an example where these values are not doing the right thing, let me know. They can be adjusted (GMT vs local time, no time-zone format vs with time-zone format) fairly easily.



    Sunday, November 12, 2017 5:24 PM
  • I believe the value for INVSTMTRS.DTASOF has always been in GMT and is the max trade/time of all the securities. Previously, since the trade/time not available, I just use current time. This is my recollection anyway. If you think that is not the case, please let me know and I will take a closer look at the code changes.


    OK,  I see now where DTASOF was in GMT but the problem may have been in the old version.  See snip below from this past Tuesday, October 3, 2017 at 4:13am EDT for the prior trading day (a Monday).  Here on US east coast, DTASOF local time was given as 20171002000000, but in setting INVSTMTRS.DTASOF the four hour time difference showed 20171002040000 where four hours were added but the day wasn't incremented to 20171003040000.  If it had been incremented, I would have needed to set a Date Offset of -1 but, as it was, I could just leave as zero.  With the new version, the local time is now coming in around 8pm EST (e.g. 20171110200000) so adding the five hour difference correctly increments to the following day (e.g. 20171111010000) and thus requires Date Offset of -1.  Not sure what will happen when we go back to DST.  At that time, we may hit the midnight issue again and a Date Offset of -1 could be a problem.

    <OFX>
      <!--Created by hleOfxQuotes on: Tue Oct 03 04:13:00 EDT 2017-->
      <SIGNONMSGSRSV1>
        <SONRS>
          <!--DTSERVER local time is 20171003041300-->
          <STATUS>
            <CODE>0</CODE>
            <SEVERITY>INFO</SEVERITY>
            <MESSAGE>Successful Sign On</MESSAGE>
          </STATUS>
          <DTSERVER>20171003081300</DTSERVER>
          <LANGUAGE>ENG</LANGUAGE>
        </SONRS>
      </SIGNONMSGSRSV1>
      <INVSTMTMSGSRSV1>
        <INVSTMTTRNRS>
          <TRNUID>B8875B32-7165-48CA-B497-999D4D6D5834</TRNUID>
          <STATUS>
            <CODE>0</CODE>
            <SEVERITY>INFO</SEVERITY>
          </STATUS>
          <!--DTASOF local time is 20171002000000-->
          <INVSTMTRS>
            <DTASOF>20171002040000</DTASOF>

    Sunday, November 12, 2017 7:08 PM
  • To keep Money from compensating for timezone differences, it would be ideal if those who create OFX files would change all time fields to 120000. Then Money will never change the date due to a timezone difference.
    Sunday, November 12, 2017 7:40 PM
    Moderator
  • Hi John,

    The value 20171110200000 is in GMT time so when Money imports the OFX file, it will treat that value as hour 15 or 3pm on the 10th. A different way to saying this:

    • All date values you see in hleofxquotes OFX files are in GMT (let's say the quote source said last trade time in EST is hour 15, then the date value in OFX will be 20 on same date; If EST trade time is hour 20 , then the date value in OFX will be (20 + 5) or hour 1 the next day.
    • If you don't mind, can you do a couple of spot check for me. Retrieve the prices, make a note of the trade/time as displayed in the price window. Concentrate on the US stocks and fund for now, make notes of the trade/time; import. Then verify in Money by checking the in "Update price manually" choice to see which date the price was added in.

    I just did a quick test using the following tests:

    https://github.com/hleofxquotes/hleofxquotes/tree/master/dist/quotes

    I believe the dates as generated is being handled by Money correctly.

    ---

    I am in California (PST) time. I created a brand new *.mny test file to try each of these tests. Best if you don't try testing on your date-to-date copy.

    ##
    quotes-test-01.ofx

      All the dates has 12th day of month in GMT to check if Money will handle GMT conversion correctly or not.

      Expect: price wil be imported with 11th date.

          <DTSERVER>20171112185717</DTSERVER>
    Sun Nov 12 18:57:17 UTC 2017
    Sun Nov 12 10:57:17 PST 2017

            <DTASOF>20171112010001</DTASOF>
    Sun Nov 12 01:00:01 UTC 2017
    Sat Nov 11 17:00:01 PST 2017

                  <DTPRICEASOF>20171112010001</DTPRICEASOF>
    Sun Nov 12 01:00:01 UTC 2017
    Sat Nov 11 17:00:01 PST 2017

              <DTASOF>20171112010001</DTASOF>
    Sun Nov 12 01:00:01 UTC 2017
    Sat Nov 11 17:00:01 PST 2017

    Money imports price with date 11/11/2017

    This shows Money is handling the GMT time conversion correctly.

    ##
    quotes-test-02.ofx

      Each of the four dates has 12th, 11th, 10th and 09th of the month in GMT, check to see which date values will be used

          <DTSERVER>20171112185717</DTSERVER>
    Sun Nov 12 18:57:17 UTC 2017
    Sun Nov 12 10:57:17 PST 2017

            <DTASOF>20171111010001</DTASOF>
    Sat Nov 11 01:00:01 UTC 2017
    Fri Nov 10 17:00:01 PST 2017

                  <DTPRICEASOF>20171110010001</DTPRICEASOF>
    Fri Nov 10 01:00:01 UTC 2017
    Thu Nov  9 17:00:01 PST 2017

              <DTASOF>20171109010001</DTASOF>
    Thu Nov  9 01:00:01 UTC 2017
    Wed Nov  8 17:00:01 PST 2017

    Money imports price with date 11/10/2017. This shows Money is using the INVSTMTRS.DTASOF value to set the price date.



    Monday, November 13, 2017 4:53 AM
  • All date values you see in hleofxquotes OFX files are in GMT (let's say the quote source said last trade time in EST is hour 15, then the date value in OFX will be 20 on same date; If EST trade time is hour 20 , then the date value in OFX will be (20 + 5) or hour 1 the next day.

    If you don't mind, can you do a couple of spot check for me. Retrieve the prices, make a note of the trade/time as displayed in the price window. Concentrate on the US stocks and fund for now, make notes of the trade/time; import. Then verify in Money by checking the in "Update price manually" choice to see which date the price was added in.


    That is correct.  With trade time coming in at hour 20, the date in OFX is hour 1 the next day.  Therefore, I need a Date Offset of -1.  I would have needed the same offset previously but trade times consistently were coming in at hour zero and the date in OFX was hour 5 (or 4 DST) BUT ON THE SAME DAY rather than the next day.  Because of that error, I didn't need an offset.  See example in prior post.

    Below is what I get now with trade time at 20:01 in the price window:

    <OFX>
      <!--Created by hleOfxQuotes on: Sun Nov 12 13:31:29 EST 2017-->
      <SIGNONMSGSRSV1>
        <SONRS>
          <!--DTSERVER local time is 20171112133129-->
          <STATUS>
            <CODE>0</CODE>
            <SEVERITY>INFO</SEVERITY>
            <MESSAGE>Successful Sign On</MESSAGE>
          </STATUS>
          <DTSERVER>20171112183129</DTSERVER>
          <LANGUAGE>ENG</LANGUAGE>
        </SONRS>
      </SIGNONMSGSRSV1>
      <INVSTMTMSGSRSV1>
        <INVSTMTTRNRS>
          <TRNUID>38D48F6E-D3CA-41DC-9D90-04F00936952E</TRNUID>
          <STATUS>
            <CODE>0</CODE>
            <SEVERITY>INFO</SEVERITY>
          </STATUS>
          <!--DTASOF local time is 20171110200124-->
          <INVSTMTRS>
            <DTASOF>20171111010124</DTASOF>

    Monday, November 13, 2017 9:32 AM
  • Hi John, let's take this one offline. Can you send me an email at hleofxquotes gmail com and I can walk you through an example.

    Best,

    Monday, November 13, 2017 5:08 PM
  • Hi,

    I find a default on the latest build about the latest date trade of mutual funds which are one or two days late compared with the stocks.

    If hlequotefix shows the good date, the download on Money is registred in the present day.

    For example,you can try with the French mutual fund LCL ACTIONS EURO (D) : FR0000018954.PA. Latest listing on 11/15/2017. Transformed in Money in the date of downloading the ofx file (11/17/2017).

    Thanks.


    Jacquouille la Fripouiile


    Friday, November 17, 2017 11:04 PM
  • 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 ...)

    Saturday, November 18, 2017 2:24 AM
  • It depends on the Time Zone of your local computer. If your Time Zone is in Europe (for example), or any other Time Zone that makes the date on the next day, you will get a repro. With that said, Money and MoneyCentral never modified the times on quotes. Money's OFX team only suggested making statement transaction dates set to Noon UTC, never quotes.

    For anyone who is downloading quotes and have their computers set to a time zone between East of the Atlantic and the International Time Zone, and are importing from US exchanges, set your computer's time zone to US Eastern Standard when you import into Money, then switch back to your desired Time Zone.


    Bob - MSN Mobile

    Sunday, November 19, 2017 6:22 PM
  • Hi,

    I find a default on the latest build about the latest date trade of mutual funds which are one or two days late compared with the stocks.

    If hlequotefix shows the good date, the download on Money is registred in the present day.

    For example,you can try with the French mutual fund LCL ACTIONS EURO (D) : FR0000018954.PA. Latest listing on 11/15/2017. Transformed in Money in the date of downloading the ofx file (11/17/2017).

    Thanks.


    Jacquouille la Fripouiile


    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.

    Sunday, November 19, 2017 8:46 PM

  • 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.

    Thursday, November 30, 2017 10:21 PM
  • Ho, it looks fine to-night. (The previous prices "Actualiser" were loaded by hand)


    Jacquouille la Fripouiile


    Thursday, November 30, 2017 11:18 PM
  • Maybe, I will have to download with other stocks to see if the date stays good.

    Jacquouille la Fripouiile

    Thursday, November 30, 2017 11:23 PM
  • It's what I feared. When in the same time, I download stocks and mutual funds, just after Paris Stock Exchange closed, the date of purchase is today's date, although the last known trade date of the mutual fund is 11/29.

    Quote.ofx shows this :

    <?xml version="1.0" encoding="UTF-8"?>
    <?OFX OFXHEADER="200" VERSION="200" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>
    <OFX>
      <!--Created by hleOfxQuotes on: Fri Dec 01 17:59:45 CET 2017-->
      <SIGNONMSGSRSV1>
        <SONRS>
          <!--DTSERVER local time is 20171201175945-->
          <STATUS>
            <CODE>0</CODE>
            <SEVERITY>INFO</SEVERITY>
            <MESSAGE>Successful Sign On</MESSAGE>
          </STATUS>
          <DTSERVER>20171201165945</DTSERVER>
          <LANGUAGE>ENG</LANGUAGE>
        </SONRS>
      </SIGNONMSGSRSV1>

    ...

    <POSMF>
                <!--DTPRICEASOF local time is Wed Nov 29 21:00:00 CET 2017-->
                <!--DTPRICEASOF GMT time is 20171129200000-->
                <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,417</UNITS>
                  <UNITPRICE>164,19</UNITPRICE>
                  <MKTVAL>68,46723</MKTVAL>
                  <DTPRICEASOF>20171129200000</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>


    Jacquouille la Fripouiile

    Friday, December 1, 2017 5:22 PM
  • Jacquouille la Fripouiile

     Did you notice the typo in your signature? Fripouiile instead of your intended Fripouille.

    • Edited by bobjbkln Saturday, December 2, 2017 4:45 AM
    Saturday, December 2, 2017 4:44 AM
  • Jacquouille la Fripouiile

     Did you notice the typo in your signature? Fripouiile instead of your intended Fripouille.


    I did not see it. How can I correct the typo ???




    Sunday, December 3, 2017 11:39 PM
  • Jacquouille la Fripouiile

     Did you notice the typo in your signature? Fripouiile instead of your intended Fripouille.


    I did not see it. How can I correct the typo ???


    I don't find, but not very important.




    Monday, December 4, 2017 12:21 AM
  • «Maybe, I will have to download with other stocks to see if the date stays good.

    Jacquouille la Fripouiile»  Thursday November 30 11:23 PM.

    Sorry, I meant your signature in the message text.  The above is one example from a short message, but the longer messages are the same.


    (Just an explanation: I did a search on your signature just to satisfy my curiosity on the source of your screen name, when nothing came up, I discovered the error in the spelling)
    • Edited by bobjbkln Monday, December 4, 2017 4:55 AM
    Monday, December 4, 2017 4:49 AM
  • Thanks for sorting this out. Very helpful.

    I've downloaded the new file to replace my old one but my original mapper.csv file isnt doig its job. I get quotes downloaded in GBP (but they are actually GBX) and it wont convert.

    Am I missing something?

    Thanks

    Sunday, December 17, 2017 10:24 AM
  • Please help!

    Up until recently, the update prices utility has been updating prices and importing into MS Money.  However, beginning today the prices will update when running the hleofxquotes tool, but when I click Import to MS Money it does not open MS Money and complete the import.

    Any direction would be much appreciated.

    Mike


    Saturday, December 23, 2017 2:58 PM
  • Can you

    • attach a copy of your mapper file (or send a copy to hleofxquotes at gmail dot com)
    • also, which quote symbol are you using?

    I will try to see if I can duplicate.

    Sunday, December 24, 2017 7:02 PM
  • Mike,

    The is an option to save to OFX file. Save a copy and see if you can manually import it?

    If that still does not work, post the copy of the OFX and I will take a look.

    Best,

    Sunday, December 24, 2017 7:03 PM
  • hleofxquotes:

    Windows 7 Home Premium 64-bit

    Java version 1.8.0_151

    helOfxQuotes-gui-Build_20171207_165-exec.jar

    I can't seem to permanently delete unwanted ticker symbols from the Symbols field of the tool.

    Deleted symbols reappear after restarting the tool.

    -Kevin N.

    Friday, December 29, 2017 3:39 AM
  • Hi Kevin,

    Can you do an "Update price" after deleting the symbols then restart and see if the changes are saved?

    I think the current codes do an implicit save only after an "Update price". I will see if that can be improved:

      * Add an explicit save menu item

      * Detect that the text has changed and text panel no longer has focus (user has moved to the mouse to another GUI component)

    Happy Holidays!

    Friday, December 29, 2017 5:56 PM
  • Kevin, 

    A new build with menu item "Save" to allow user to explicitly save the current list of symbols.

    https://github.com/hleofxquotes/hleofxquotes/tree/master/dist/test/Build_20171230_168

    See README file.


    • Edited by hleofxquotes2 Saturday, December 30, 2017 5:37 PM Update download link to latest
    Saturday, December 30, 2017 12:49 AM
  • Hi Hleofxquotes,

    Thank you for your reply.

    I had entered 1 ticker (WTAN) under the FT tab to test it for a Moneydance user.  I primarily use the Yahoo2 tab.

    WTAN is the only symbol under the FT tab.  I can not run an update on the FT tab once the symbol WTAN is removed.  If I delete WTAN on the FT tab and run an update on the Yahoo2 tab, then restart, WTAN on the FT tab returns.

    I can replace WTAN with something else. e.g. IBM.  WTAN then goes away but IBM then becomes the new symbol that doesn't go away.

    I will try the new Build_20171230_168 and report back to you.

    Thank you again for your work on this tool.

    -Kevin N.

     

    Sunday, December 31, 2017 6:27 PM
  • Kevin,

    I see what you mean now. In new version, using the explicit "Save" will fix your problem.

    Previously, deleting WTAN will leave an empty list which will prevent you to do an update. Since the list only saved after an update, we are sort in a "deadlock" ;-). Since no save could occur, the WTAN will return after restart.

    Best,

    Sunday, December 31, 2017 6:37 PM
  • Hi hleofxquotes,

    I tried Build_20171230_170.

    Using the File > Save pop-up, in the 'Symbols' area, has resolved the issue of deleted symbols returning on restart.

    Thank you.  Well done Sir.

    -Kevin N.

    Sunday, December 31, 2017 6:45 PM
  • Sorry for the delay.  Tried saving to an OFX file and importing but that did not work either.  Thanks much for responding.  Below is the data from my mapper file.  If you need something different, please let me know and I will be happy to provide you with whatever you need to get this functional again.  This is such a great utility when it is working.

    MSMoneySymbol QuotesSourceSymbol IsMutualFund IsOptions QuotesSourceCurrency
    BBT BBT:NYQ USD
    BBT2 BBT:NYQ USD
    BBT BBT USD
    AAPL VPRNX
    AAPL VPRMX
    FIMGC FIMGC TRUE
    AAPLOPT1 AAPL110219C00220000  FALSE TRUE
    $INX ^GSPC TRUE FALSE
    VINCI DG.NX FALSE FALSE EUR

    Monday, January 1, 2018 3:43 PM