I need someone who can execute queries, from within Excel VBA such as the following:
[login to view URL],THB,HKD,GBP,EUR&base=USD
To retrieve currency data and then paste it into excel cells.
The HTTP query from within VBA is quite simple to build. Example:
str = "[login to view URL]" _
& "&start_at=" _
& Year(startDate) & "-" & Month(startDate) & "-" & Day(startDate) _
& "&end_at=" _
& Year(endDate) & "-" & Month(endDate) & "-" & Day(endDate) _
& "&base=" _
& fromCurr _
& "&symbols=" _
With Sheets("Data").[login to view URL](Connection:="URL;" & str, Destination:=Sheets("Data").Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.SaveData = True
After you will get a long string (in Cell A1) and then need to separate it and put the right values in the right cells in the rest of the sheet. Refer Attached file for example of layout.
At the top of the sheet you will see two rows of currencies. The first row is the Base currency and the second row is the target currency. If you are clever you can construct the query so you only have to execute 3 requests (as there are only 3 base currencies) and you can get all the data for the target currencies in the one query.
When running, it should check on the left side what is the last date and then start to fill the data out from there onward to the current date (now). (Note: The currency values change within the current day, so I want to always re-obtain and replace the last values (last row) in the sheet for when running again).
The VBA needs to populate the date column with new dates (days) up to the current date.
For a good Excel VBA programmer this would be about 4-5 hours work.
9 freelancere byder i gennemsnit $123 på dette job
Hi there! Dear colleague. I can help you with this VBA project. I would like to know more about it. Contact me by Chat to get more information. I can start this project now. My Best Regards
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.