Completed

Build an Excel Template which converts USD to GBP by certain date using Oanda

Hello,

I'm looking to get an Excel template where I could paste my PayPal transactions, which have a Date attached to them and a Gross profit number, Fee, and Net profit.

I need an Excel sheet that I could paste these figures in USD and the date, and it'll output the figure in GBP for that same date.

For example, on the 05/04/2019 there's been a transaction for $24.99. I need that the Excel document will automatically reach out to Oanda and check this amount on that date and will output next to the Gross column the $24.99 in GBP for that date.

Some references which can help:

Here's a function of someone who already made a function that checks with Oanda and returns a value, however I wasn't able to make the function work using Excel. It might need some revising, but can be a good starting point:

[login to view URL]

And this is the sample code that the person who wrote it said to use, but didn't work for me:

=GetOandaFX("USD","GBP","6/18/2016")

Please also find attached a sample of the Excel sheet of which I would ideally copy and paste into the Template that I'm looking to get made, which will then output the currency from USD to GBP on that date. You'll see that every line have the Date, as well as all the three figures to be converted (Gross, Fee, Net) so it should that the document can combine these inputs and request it from Oanda.

Please let me know in case you've any questions and I'd love to explain in detail in case you need further guidance.

Best,

Tim

Skills: Excel, Data Entry, Visual Basic, Data Processing, Software Architecture

See more: excel template service, excel template designer, excel template workers money, excel template price part number configurator, importing xml excel template, quick books excel template, list excel template, build joomla template photoshop, excel template invoice freelance, quickbooks pro excel template, find dividend dates certain date excel, excel template build, excel to send email notification on certain date, expiration date tracking excel template, excel template with date picker

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #23054958

Awarded to:

nvchien94

hello there, I am an Excel coder and I can do this one for you,. With existing code I think it will need small adjustments to work. please contact, we can start now and finish within 1 hour.

$40 USD in 1 day
(160 Reviews)
6.0

34 freelancers are bidding on average $99 for this job

asin1987

Dear Employer, Wishing you a Merry Christmas and a Happy New year!! I perfectly understand your job. You need to automate to automate your Lookup job so as to easy up your efforts. Please message me, I am an expe More

$200 USD in 2 days
(219 Reviews)
7.8
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not More

$155 USD in 3 days
(59 Reviews)
6.6
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting informati More

$130 USD in 5 days
(152 Reviews)
6.1
usmanhassan123

I can build this sheet by using Excel VBA and macro's. I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects More

$150 USD in 1 day
(82 Reviews)
6.3
younus15

Hi mate. I can do your project in less than 24 hours (First part of your project). I can create a convertor in Google sheet with the yahoo exchange rate and refresh each min. If it can help you please let me know. Bes More

$120 USD in 1 day
(126 Reviews)
6.1
rashedkhanrubel

Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

$55 USD in 1 day
(74 Reviews)
5.2
apuspo49

[login to view URL], yes i can make this excel sheet where it will live update the dollar to gbp price. I check the sample. Thanks anjuman

$140 USD in 7 days
(21 Reviews)
4.9
AnowarRatul

$ 30 Only ------ In just 4 hours ----- Excel VBA Macro Coding Formula Generation and Automation Expert with 5* rattings. ---- 100% accuracy is my priority with your 100% satisfaction.

$30 USD in 1 day
(58 Reviews)
4.7
GaryMoylan

Hi there, I'm a pro developer and can code the solution you have asked for, which will pull historical rates from the currency site you've mentioned. I can also create a video for you to show you how I did this, so More

$135 USD in 2 days
(6 Reviews)
4.2
Prompty

Hi, i can simplify this problem in a different way. I am an EXCEL expert. I have developed many progarms. One of the sample is portfolio management. Let us discuss over chat the details, as it is not appropriate to More

$65 USD in 2 days
(11 Reviews)
3.9
ravinderkumar248

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forwar More

$72 USD in 3 days
(8 Reviews)
3.2
sharmapritam311

Hi there. I have very good experience in handling advanced excel automation using VBA. I also love to write small macros for solving some really crazy and stupid problems. I would love to solve this one.

$50 USD in 1 day
(6 Reviews)
2.7
meetbhagat

I have the required skills that you are looking for. I have been working with Customer Service Representative with IT background, bit of data entry, My business is built on the delivery of quality services like Custome More

$32 USD in 2 days
(1 Review)
1.8
Muhammad6979

Hello, Dear Sir/Madam, You can see my profile I do have the relevant skill and can provide you up to the mark services. Thanks & Regards Muhammad Ilyas Saeed

$30 USD in 7 days
(5 Reviews)
1.8
Softwcreative

Client, i have read your project specification and i am the right vb programmer to develop it for you, lets discuss details and i can start coding it. i have the listed skilled to complete the project. Thanks.

$140 USD in 3 days
(3 Reviews)
1.5
DTechs

yes----------------------------------------------------------------------------------------------------------------------------------------------------------------------

$250 USD in 1 day
(4 Reviews)
2.1
sanjaythyagu

Being an IT professional with 6+ years of experience and an expert in MS Excel I am sure I can complete the work o your full satisfaction. Relevant Skills and Experience I am currently working on projects which involv More

$100 USD in 5 days
(0 Reviews)
0.0
akanshamehra8

hi there let me know the details and hour for working .so let me know the process . hi there let me know the details and hour for working .so let me know the process . hi there let me know the details and hour for work More

$35 USD in 10 days
(0 Reviews)
0.0
TaiZhe0224

Hi, there. I am a senior software developer and have more than 10 years of development experience. After reading your description, I am interested in your project. As I am a software developer, I have developed the VB, More

$150 USD in 5 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0