Home → Investments →

Wrong currency used for HK$ securities

• Edit

pierre-henri

14 Jun, 2025 08:29 AM

Hi to everyone,

I need your help concerning the way "quote loader" is dealing with HK$ translation into Euro.
I have securities on HKEX (in HK$) and they are translated into Euro in the Summary page with the Chinese "Yuan" Renminbi rate. This is inflating my portfolio by 10%ish (when converted into Euro).
I have no securities in CNY.
Is it a fix in quote loader necessary or somewhere else?
I would really appreciate any kind of support.
Have a good day
Pierre-Henri

1. 1 Posted by Stuart Beesley ... on 14 Jun, 2025 09:30 AM

   

   Please send screenshots (SSs) of

   tools/security/edit for that security
   tools/currency/edit for that currency
   QL screen showing that security

   • Edit

2. 2 Posted by derekkent23 on 14 Jun, 2025 09:41 AM

   

   I am not support staff, just a user.
   Hi Pierre-Henri

   Can you confirm your base currency is Euro. When you set up the security what currency did you set. What source in Quote Loader are you using. What’s the ticker.
   take a screenshot and post of the Quote Loader window after you click GET PRICE but before you save.

   • Edit

3. 3 Posted by pierre-henri on 14 Jun, 2025 02:07 PM

   

   Hi Stuart,

   not sure how to do this, using toolbox or quote loader?
   Here attached SS of quote loader showing the HKEX security and the currency associated to them.

   • Screenshot_2025-06-14_at_16.05.35.png 524 KB
   • Edit

4. 4 Posted by pierre-henri on 14 Jun, 2025 02:10 PM

   

   Hi Derek,

   yes, base currency is Euro. I setup the HK$ as currency for the HKEX securities I am having. I use now FT as source (was the same with Yahoo). The currency table in quote loader doesn’t show HK$ as currency but Chinese Yuan.
   See screenshot.
   Thanks
   Pierre-Henri

   • Screenshot_2025-06-14_at_16.05.35.png 524 KB
   • Edit

5. 5 Posted by pierre-henri on 14 Jun, 2025 02:35 PM

   

   Sorry, I found it!

   You can see that the conversion from HK$ to Euro is not using the right FX rate.

   • Screenshot_2025-06-14_at_16.30.16.png 28.1 KB
   • Screenshot_2025-06-14_at_16.30.42.png 115 KB
   • Screenshot_2025-06-14_at_16.31.37.png 15.1 KB
   • Edit

6. 6 Posted by derekkent23 on 14 Jun, 2025 04:35 PM

   

   I am not support staff, just a user.
   Hi Pierre-Henri

   Under TOOLS- CURRENCY select and double click on Hong Kong Dollar then EDIT. Ensure Show on summary page box is ticked.

   Now in Quote Loader Exchange rates currency Ticker HKD should be listed.

   Click Get Exchange Rate. Select all lines. Save Selected Lines.

   Now click Get Prices and see what the New Prices are now.

   See Screenshots.

   Hope this helps.

   • Edit

7. 7 Posted by derekkent23 on 14 Jun, 2025 04:36 PM

   

   I am not support staff, just a user.
   Hi Pierre-Henri

   Sorry forgot screenshots

   • HKD.png 44.8 KB
   • 1093.png 93.7 KB
   • Edit

8. 8 Posted by pierre-henri on 14 Jun, 2025 05:12 PM

   

   Thank you so much.

   I did all this and the HK is appearing and I cancel the CNY from the list but the HK$ FX is not the one I am getting from FT, (maybe due to closing of market and the currency does not get refreshed today?).

   I still have the HK$ at 0,1189 /Euro where it should be at 0,1102.

   I will check during the week whether the FX is getting right.

   If you have any other idea.

   I appreciate(d) very much your help.

   Have a nice evening

   Pierre-Henri

   • Screenshot_2025-06-14_at_19.01.11.png 56.1 KB
   • Screenshot_2025-06-14_at_19.03.02.png 116 KB
   • Screenshot_2025-06-14_at_16.05.35.png 524 KB
   • Edit

9. 9 Posted by derekkent23 on 15 Jun, 2025 09:58 AM

   

   I am not support staff, just a user.
   Hi Pierre-Henri

   Try changing the Exchange Rate source to Yahoo HD instead of FT. With FT you only get the latest exchange rate. With Yahoo HD you get history. Quote Loader attempts to use the Exchange Rate to match the Trade Date of the Security which may be a few days older.

   In the attached screenshot the Last Update is given as on 13/06/2025. This is the date of the last retrieved price by Quote Loader. However the Euro value is based on the latest exchange rate which is dated the 15/06/2025.

   Hope this helps.

   • Calculation.png 126 KB
   • Edit

10. 10 Posted by Stuart Beesley ... on 15 Jun, 2025 03:09 PM

    

    Exactly as Derek says… But I’m confused why HKD is not appearing in your QL screenshots? Is it there now? Why was it missing? Can you set China CYN to do not load if your not using it and can you check that CYN tools/currencies/edit is not using the same ID as HKD?

    Also, as suggested. Set all your sources to xxHD. That’s important for you.

    • Edit

11. 11 Posted by pierre-henri on 15 Jun, 2025 04:42 PM

    

    Hi Stuart,

    I took out CNY from the QL currency and add HK$, now it is showing the right FX rate (11,02) and the total in Euro is right.
    Thank you both for your answer and helping me to solve this issue.

    Pierre-Henri
    ________________________________
    Von: Stuart Beesley (Mr Toolbox) <[email blocked]>
    Gesendet: Sonntag, Juni 15, 2025 5:10 PM
    An: Pierre-Henri Bruchon <[email blocked]>
    Betreff: Re: Wrong currency used for HK$ securities [Investments #9500]

    • Edit

12. 12 Posted by derekkent23 on 15 Jun, 2025 07:04 PM

    

    I am not support staff, just a user.
    Hi Pierre-Henri

    Glad we were able to help.

    Have Fun, Stay Safe.

    • Edit

13. 13 Posted by Stuart Beesley ... on 16 Jun, 2025 09:23 AM

    

    Just to add. The reason that EUR was not shown on the QL screen was that it was the base currency (always 1).... The base currency is never shown...

    • Edit