Excel - Simple VBA to download currency data

In Progress Posted 5 years ago Paid on delivery
In Progress 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.

Excel Visual Basic Visual Basic for Apps

Project ID: #18204479

About the project

8 proposals Remote project Active 5 years ago

8 freelancers are bidding on average $133 for this job

citijayamala

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

$150 USD in 3 days
(69 Reviews)
5.8
dalsaniyasonu123

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.

$111 USD in 3 days
(44 Reviews)
5.2
gr8tech

Hello there I am available to help you build a VBA script to construct the HTTP queries and obtain the required infromation from the resulting url endpoint. I have worked with numerous REST APIs, with results in JSON More

$133 USD in 1 day
(44 Reviews)
5.2
dany3j

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

$88 USD in 1 day
(29 Reviews)
4.9
dataexplorer

"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

$150 USD in 3 days
(18 Reviews)
4.3
Imdadulhaqu

I am efficient data entry operator

$155 USD in 3 days
(0 Reviews)
0.0
nataliaomelchenk

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.

$120 USD in 3 days
(0 Reviews)
0.0