Newsroom Update

New features come to Apple services this fall. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

"MYR" not function in CURRENCYCONVERT formula

Hi


My formula is : CURRENCYCONVERT(B7,"MYR")


but it popup error : Data for the ‘CURRENCYCONVERT_ARGUMENT_2_MODE_0’ attribute isn’t available for the selected symbol.



I had change to another currency as USD/VND/EUR/SGD is no issue.

May I know why just MYR is not possible?


Thanks for support!


MacBook Pro with Touch Bar

Posted on Jul 30, 2021 9:12 PM

Reply
Question marked as Best reply

Posted on Jul 31, 2021 3:48 AM

All the functions that rely on retrieving data from Yahoo Finance are flaky. They work sometimes and fail sometimes for no apparent reason. I tried "MYR" and it worked here this morning but "EUR" fails. Yahoo's service to Apple is trash. I hope Apple gets it for free, though it is not worth it even then.


5 replies
Question marked as Best reply

Jul 31, 2021 3:48 AM in response to Jaron Hoh

All the functions that rely on retrieving data from Yahoo Finance are flaky. They work sometimes and fail sometimes for no apparent reason. I tried "MYR" and it worked here this morning but "EUR" fails. Yahoo's service to Apple is trash. I hope Apple gets it for free, though it is not worth it even then.


"MYR" not function in CURRENCYCONVERT formula

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.