Quote dates are one day later than the actual date

[GoogleCodeExporter]

What steps will reproduce the problem?
1. update stock prices
2. import to money
3. look at imported quote date

What is the expected output? What do you see instead?
date is one day ahead of correct quote day, price is correct date is t+1

What version of the product are you using? On what operating system?
20111104_01, windows

Please provide any additional information below.

using microsoft money plus, using yahoo prices, problem does not happen every 
time

Original issue reported on code.google.com by djmeb...@gmail.com on 2 Feb 2012 at 1:44

[GoogleCodeExporter]

UPDATE: version Money Plus Sunset v17

Original comment by djmeb...@gmail.com on 2 Feb 2012 at 2:21

[GoogleCodeExporter]

Couple of things:

  . Which timezone are you in?

  . It might be that the quote source has only "yesterday" price at the time of import. Can you take a look at the price table which should show the actual quote date. Notably, mutual fund is only calculated at end of day.

  . Also beware that MSMoney only update the price in the *.mny file ONCE per day. For example, 
   at 8:00am on Friday, you imported, the price of MUTUAL_FUND1 is from Thu
   at 6:00pm on Friday, you imported again, even though the price for Friday is now available, you *.mny will still have the Thu Friday.

 The above behavior is Money's specific and there nothing we can do to change that. There are work-around by using sunriise to delete the current price but it is probably more trouble than it worths.

Original comment by hle...@gmail.com on 3 Feb 2012 at 6:13

• Changed state: Accepted

[GoogleCodeExporter]

Thank you for the feedback.  I am in EST.  I look at the downloaded quotes to 
make sure the date is correct.  I have deleted incorrect prices and tried 
reloading the ofx file but it doesn't correct the issue.  I am also aware of 
the once per day update.  I just can't figure out what the variable is that 
causes the problem.  It doesn't happen all the time.  Today the date was 
correct (2/3).  Yesterday I skipped importing because the 2/1 dates came in as 
2/2 dates and I couldn't change that no matter what I did.  I  tried copies of 
the mny file but they all updated to the wrong date.  What really is curious is 
the date is correct in the OFX display but import showing a day later.  It must 
be something in money.  I even tried changing the computer date back by one day 
but got the same issue.

Original comment by djmeb...@gmail.com on 4 Feb 2012 at 1:04

[GoogleCodeExporter]

The problem is in the quote source.  If you open up the ofx file that is 
generated, line 26 is DTASOF (date as of).  I find that typically line 26 will 
be the current business day's date until about 8PM EST after which it will be 
the next business day's date (except last business day of week which will then 
change on day before next business day).

My understanding is that this is one of the reasons for the Date Offset feature 
as explained in the notes for Build_20110213_001; see 
http://code.google.com/p/hle-ofx-quotes/wiki/Build_20110213_001

Since DTASOF on line 26 of the generated ofx doesn't always behave predictably, 
I leave the Date Offset feature set to zero and manually check the ofx file 
each time to make sure DTASOF is set to the date I want.  In the generated ofx 
file, Money does not care what the individual quote dates are (DTPRICEASOF - 
date price as of).  Money only cares about DTASOF and will set the date for 
each imported quote to that date.

Depending on the number of quotes you're importing, if you want to correct a 
bad import delete the old quotes and re-import with the corrected ofx.  This 
can be done the same day regardless of Money's "once per day" issue since 
typically the correction is done due to wrong date.  Money will only be "once 
per day" if DTASOF is the same each import.

Original comment by johnbusc...@gmail.com on 6 Feb 2012 at 11:22

[GoogleCodeExporter]

John..thank you for the very useful information.  You seem to have identified 
the problem and nailed the solution.

Original comment by djmeb...@gmail.com on 6 Feb 2012 at 1:41

[GoogleCodeExporter]

I am also having this problem with one of my mutual fund quotes (WTIBX).  31 of 
32 quotes have the proper date but one particular mutual fund has a one-day 
later date, WTIBX, making the import unsuccessful. This happens frequently so i 
have to delete this entry from my list and update it manually which is not a 
big deal. Still curious why it happens though...

Original comment by mccj...@woh.rr.com on 20 Dec 2013 at 7:48