Excel - Simple VBA to download currency data
$30-250 USD
Paid on delivery
Hi,
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=" _
& toCurr
QueryQuote:
With Sheets("Data").[login to view URL](Connection:="URL;" & str, Destination:=Sheets("Data").Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
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.
Project ID: #18204479
About the project
8 freelancers are bidding on average $133 for this job
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More
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.
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, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor More
Hi. You are right. I can do it in 1 day at last. I have checked api already. No problem. I will do my best for you. Best regards.