Excel - Simple VBA to download currency data

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.