Færdiggjort

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.

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: excel download yahoo data, excel spreadsheet vba data entry form, excel vba access sheet data, excel exchange rate formula, excel exchange rate web query, excel currency conversion macro, live currency in excel, import currency rates into excel, vba exchange rate, real time currency converter excel, excel 2016 exchange rate, excel currency data download, excel vba return xml data type, vba excel pop gui user input data, excel simple macro data comparing copy, excel download database excel 2000 vba, refresh web data excel 2007 vba, excel vba update imported data, excel vba speed filling data, download currency data yahoo

Om arbejdsgiveren:
( 21 bedømmelser ) Lumpini, Pathumwan,, Thailand

Projekt ID: #18204479

Tildelt til:

mtdevil369

I am a Professional VBA Programmer with +5 years of experience in excel automation and I am here to provide you one stop solution for your excel [login to view URL] me.i will start your work now i am ready for your w Flere

$47 USD in 0 dage
(62 bedømmelser)
5.2

9 freelancere byder i gennemsnit $123 på dette 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 Flere

$150 USD in 3 dage
(57 bedømmelser)
5.4
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 Flere

$133 USD på 1 dag
(36 bedømmelser)
5.0
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 på 1 dag
(17 bedømmelser)
4.2
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 Flere

$150 USD in 3 dage
(15 bedømmelser)
3.4
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 dage
(14 bedømmelser)
3.6
Imdadulhaqu

I am efficient data entry operator

$155 USD in 3 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
0.0
$155 USD in 3 dage
(0 bedømmelser)
0.0