Time Zone and the Value Change column

[Marcel]

I like using the Value Change and % Change columns to keep track of daily movements, but it's not reporting correctly in the New Zealand timezone.

Is there a way to align the daily reset with the local time zone?

Thanks,
Marcel

[Mark]

Hi Marcel,

The Portfolio Editor reports data as of the current time on your computer. I suspect the problem may be with your recorded data. If you open up an investment in the Data Register and look at the "Prices" data type do you have pricing data for the current date and yesterday?

[Marcel]

Hi Mark

The prices date is still yesterdays, but it is updating it with today's data.

Example: MRP.NZ
Closed at 2.84 last night and dropped to 2.82 today. The 28/10/14 line shows close as 2.82 and high-low as 2.820-2.810, which are today's values. Today is 29/10/14. It's 10:46 at the moment and I expect the date to change later in the afternoon.

Regards,
Marcel

[Mark]

Hi Marcel,

What quote server are you retrieving this price from?

[Marcel]

Yahoo - ASX & NZ

The date changed over between 1 and 1:30pm NZDST, meaning I last checked before 1pm and then again at 1:35, when it changed over. We should be UTC+12 at the moment.

Thanks,
Marcel

[Mark]

Hi Marcel,

When retrieving from Yahoo ASX/NZ it is using the data from the "Download Data (delayed)" link in the lower right corner of the summary quote page:

https://au.finance.yahoo.com/q?s=MRP.NZ&ql=1

If you click on that "Download Data (delayed)" link it will download a CSV file that has pricing data, and it has a date. That is the date used to update that price in Fund Manager. You can check this tomorrow to see if the date is wrong. It sounds like it was reporting yesterday's date earlier, when it should have been today's date.

If the date provided by Yahoo is incorrect you can override the behavior using adjust_date and force_def_date. See the very bottom of this page:

https://www.fundmanagersoftware.com/intrtv.html