Find Jobs
Hire Freelancers

Web interface, Oanda to Excel

$10-200 USD

I përfunduar
Postuar about 5 years ago

$10-200 USD

Paguhet në dorëzim
This function allows for import of Oanda Currency Exchange rates into Excel, Oanda has an At Rest API interface. This plug in will allow for import of Oanda data on demand. This API allows for import of Oanda Data to excel, it will consist of two functions, a historical function and current price function: =Oanda(FromTo,StartTime,Periodicity,TimeBack) where: FromTo: is the currecy pair, example "EURUSD" StartTime: is the hour the data starts, example "00:00" for 00:00 local time Periodicity: periodicity is the time the hours are generated from: 1 minute, 1 hour, 1 day TimeBack: the time back to run the analysis from, example 1 year, 10 years, starting from latest data Output will be a sequence of the Date, Open, Close, High, Low Excel function 2: CurrentPrice(FromTo) Gives the latest price, with inputs: FromTo being the ticker: such as EURUSD There will also be an AUTOMATED LOGIN, where I put in login information ONCE and then it will automatically log in as needed to update data whenever a data pull is requested. Updating: the updates will be done once when the function is input, then will not refresh again (unless the function is input again). Oanda Data source URL: [login to view URL] Attached is an image showing the desired input, and what Excel would output (not real numbers). Final project code will be able to be edited by myself but will not be sold, uploaded, or distributed to any other parties.
ID e Projektit: 18968567

Rreth projektit

2 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Greetings! Just one question on the requirements "Updating: the updates will be done once when the function is input, then will not refresh again (unless the function is input again).". It is my understanding that the functions should be working on demand and not automatically refresh data - is that correct? Also, I am presuming you already have your Personal Access Token for me to use for development and testing. I can come up with the macro to achieve the desired functionality from Excel. Have a Great Weekend! Srinivasan Krishnamoorthi
$120 USD në 5 ditë
5,0 (87 përshtypje)
6,2
6,2
2 freelancers are bidding on average $160 USD for this job
Avatari i Përdoruesit
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$200 USD në 5 ditë
4,9 (198 përshtypje)
7,6
7,6

Rreth klientit

Flamuri i UNITED STATES
United States
0,0
0
Mënyra e pagesës u verifikua
Anëtar që nga qer 6, 2015

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.