В работе

Web interface, Oanda to Excel

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.

Квалификация: Обработка данных, Excel Macros, Excel VBA, Web API

Показать больше oanda api, oanda maintenance, oanda api python, oanda funding, oanda wiki, oanda statements, oanda web, oanda login, configure web interface cisco, freeswitch web interface, download web page using excel vba, php web interface edit xml file, backup software web interface, excel web interface, web interface pptp server login, web interface excel database, voip phone web interface default login free, xbmc web interface login apple, login routers web interface, adempiere web interface default login

О работодателе:
( 0 отзыв(-а, -ов) ) United States

ID проекта: #18968567

Поручен:

ksriniravi

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 tha Больше

$120 USD за 5 дней(-я)
(77 отзывов(-а))
6.2

2 фрилансеров(-а) в среднем готовы выполнить эту работу за $160

schoudhary1553

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. Больше

$200 USD за 5 дней(-я)
(187 отзывов(-а))
7.5