2
I am trying to extract quote data from the following website: https://bancdebinary.com/es/
For this I am trying to use the source code of the site. The problem is that I cannot find in the source code the information I need, such as being the euro price against the dollar.
You can give me a hint?
you could show what you have tried? What does it mean that you tried to use the code of the site? Is there any example in VBA on the site? If there is, you could show the link?
– cantoni
I try to use the example available at the following link: http://scriptorium.serve-it.nl/view.php?sid=40 The problem is that no source code appears for the quotation information.
– Alejandro
your question lacks details. If you posted the part of the code where you interpret the HTML of the site would already help, besides, of course, to show in an image what you are trying to get from the site, that is, a print-screen showing exactly where the quotation is. Anyway, as it comes to Quotation data, you’ve seen this: https://openexchangerates.org/ . From what I could analyze the HTML of the site, you will have work to interpret it with VBA only. The above site solution looks very interesting and easy to use, it is a JSON API.
– cantoni
Openexchangerates.org has a free option: (https://openexchangerates.org/signup/free). With this option you can make 1000 quotation changes per month. If you need more then you need to pay.
– cantoni
Cantoni, Thank you for your answers. Actually I need to extract a quote every 60 seconds.
– Alejandro