Canada Mutual Funds providing wrong values

[shaneyamkowy]

sorry an update, I corrected an error in syntax, but still getting mismatched change values on CIBC Global Monthly Income Fund F = 0P0001K9S3

For Nov 22, =muFunds("change", 0P0001K9S3) gave a value of $0.0034, but the actual change according to morningstar and globe and mail web sites was $0.0118.

The NAV value is correct

Any ideas? Help?

[joseballester]

Hi @shaneyamkowy, thanks for sharing your issue.

First of all, the 1-day change returned by the option change is a percentage, so 0.0034 represents a +0.34% (not $).

Apart from that, you are completely right that the returned value is not correct. I think it has something to do with currencies, so please let me investigate a bit and I'll get back to you as soon as I fix it.

[shaneyamkowy]

Thx Shane Yamkowy

…

________________________________ From: José Ballester ***@***.***> Sent: Saturday, December 9, 2023 9:58:55 AM To: joseballester/muFunds ***@***.***> Cc: Shane Yamkowy ***@***.***>; Mention ***@***.***> Subject: Re: [joseballester/muFunds] Canada Mutual Funds providing wrong values (Issue #62) Hi @shaneyamkowy<https://github.com/shaneyamkowy>, thanks for sharing your issue. First of all, the 1-day change returned by the option change is a percentage, so 0.0034 represents a +0.34% (not $). Apart from that, you are completely right that the returned value is not correct. I think it has something to do with currencies, so please let me investigate a bit and I'll get back to you as soon as I fix it. — Reply to this email directly, view it on GitHub<#62 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AZZH42B4A47EJC5IKIFLJUDYISKE7AVCNFSM6AAAAAA7W6XUF2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBYGU3TQNJTGQ>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[shaneyamkowy]

I thought it might be currency but I checked and it's not a CDA us exchange that does not work. Thx for looking after it Shane Yamkowy

…

________________________________ From: José Ballester ***@***.***> Sent: Saturday, December 9, 2023 9:58:55 AM To: joseballester/muFunds ***@***.***> Cc: Shane Yamkowy ***@***.***>; Mention ***@***.***> Subject: Re: [joseballester/muFunds] Canada Mutual Funds providing wrong values (Issue #62) Hi @shaneyamkowy<https://github.com/shaneyamkowy>, thanks for sharing your issue. First of all, the 1-day change returned by the option change is a percentage, so 0.0034 represents a +0.34% (not $). Apart from that, you are completely right that the returned value is not correct. I think it has something to do with currencies, so please let me investigate a bit and I'll get back to you as soon as I fix it. — Reply to this email directly, view it on GitHub<#62 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AZZH42B4A47EJC5IKIFLJUDYISKE7AVCNFSM6AAAAAA7W6XUF2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBYGU3TQNJTGQ>. You are receiving this because you were mentioned.Message ID: ***@***.***>