You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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 Top-ranking 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 Top-ranking 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 Account.