Hello,
I am obtaining exchange rate for my currency pair (USD/CZK) from Yahoo via additionally written function.
Sice the function works well thanks to JasperD and skywritter, I can't operate with it by reference.
I mean, when I eneter into cell "=150/C5" where C5 is a value of exchange rate it receives "#VALUE!".
Does somebody know how to make it works, please?
Thanks in advance.
Hi Jirakst
May be there is a text in C5
So to avoid error try
Attach you UDF Function ..It must treat Currency as text
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Can you attach an Excel sheet?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you YasserKhalil and Glenn Kennedy.
I have attached the sheet below, hope it will be usefull.
The issue is related to cell H3 and T column.
Trade Journal.xlsm
Last edited by jirakst; 05-10-2015 at 11:23 AM. Reason: typo
Nobody knows?
Any help will be appreciate.
Blast! I just lost my detailed reply. Anyhow. Several problems. Your data feed was returning text that I couldn't see how to convert back to a number. I have created an alternative (CTRL ALT F5 to refresh) and have extracted the rate (as a number) from the returned string (Sheet1). Your formulae in T were not locked on the cell reference of the exchnge rate, so the formulae returned nonsense as you copied down. Finally, T was formatted as date - now formaated appropriately.
Change this line in the function:
to this:Please Login or Register to view this content.
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
I know nothing about VBA - so thanks - romperstomper....
Thank you both very much. It works nice now and I'm being enjoyed to learn something new about excel. Thanks!
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks