Hao Ting Toong asked 1 year ago
When using excel to get the P/E graph for chinese companies listed in the US stock exchanges, must we convert the CNY EPS into USD?
Victor Chng answered 1 year ago
Hi Hao Ting,
Yes you need to convert the EPS to USD in order to plot the PE chart. To get an accurate chart, you need to take the forex exchange rate during the individual years EPS.
Hao Ting Toong
replied 1 year ago Just to check, are the average exchange rates for each year in the table in the website below accurate to be used for converting cny to usd?
https://www.macrotrends.net/2575/us-dollar-yuan-exchange-rate-historical-chart
Jieren Zheng
replied 1 year ago I remember yahoo finance has this currency conversion with you being allowed to select dates but not sure if they still have it.
Victor Chng
replied 1 year ago Hi JR,
That is something new to me. Do you still remember how to do it?
Jieren Zheng
replied 1 year ago Hi Victor,
I don’t use it anymore, I switched to this website instead:
https://www.exchange-rates.org/Rate/HKD/SGD/7-13-2021
It is more cumbersome to use though, because you need to specify the pair and the date, M-D-YYYY.
Victor Chng
replied 1 year ago ic thanks for sharing :)
Please login or Register to submit your answer