webpage fx rates

[philfer]

Hello,

I am trying to get some exchange rates from a website. I have input all the input elements but it only gives me the default GBP USD rate but not the rate I want.

This is what I have :-

objIE.Visible = True
objIE.navigate ("https://www.oanda.com/currency/converter/")
Do
DoEvents
Loop Until objIE.readyState = READYSTATE_COMPLETE
objIE.document.getElementById("quote_currency_input").Value = "Euro"
objIE.document.getElementById("base_currency_input").Value = "Singapore Dollar"
objIE.document.getElementById("end_date_input").Value = "Apr 6, 2019"
objIE.document.getElementById("form_quote_currency_hidden").Value = "EUR"
objIE.document.getElementById("form_base_currency_hidden").Value = "SGD"
objIE.document.getElementById("form_end_date_hidden").Value = "2019-04-06"
objIE.document.getElementById ("post")
Do
DoEvents
Loop Until objIE.readyState = READYSTATE_COMPLETE

Debug.Print objIE.document.getElementById("base_amount_input").Value


Please help

Many thanks
Phil

[kpangfb0630]

Yo. Those hidden parameters are not for processing the data conversion in the site you mentioned.