I gang

Integration of Lindo API in Excel (and Metatrader)

I need to implement Lindo's API for optimization in Excel, and as a second step in Metatrader.

Lindo is a company offering optimization products, and their API will be used for optimizing portfolio models in excel. You can read more about Lindo API here ([url removed, login to view]) and the reference documents here ([url removed, login to view]).

What is needed is an Excel macro, that sends and retrieves the information from the Lindo API. The following is VERY important:

In excel, I will have a few columns with inputs, and then columns with the output. Each row is treated individually, hence each row is it's own optimization. I need the API to be used from a cell with a simple function (ie. =OPT(input1, input2,...,output)) to return the optimized value/array of optimized value. Since this function will run for for each row at least a thousands times, it's important that I can just drag the cell down for all rows so it minimizes the manual work. I will provide you with an example file when the project starts.

When this works, I will want to take the next step and implement it in other applications such as Metatrader or Multicharts. However if you only have knowledge about Excel, please mention this when you quote the project as I might go with only the Excel implementation instead.

Færdigheder: C++ Programmering, Excel, Metahandel, Visual Basic

Se mere: lindo api, lindo excel, metatrader api excel, excel lindo, lindo api excel, lindo read excel, lindo php api, lindo excel api, excel api metatrader, api excel metatrader, simple excel output api, read pdf macro, works need excel, article visual basic, lindo api manual, excel metatrader, metatrader excel, simple api work, multicharts, metatrader c, macro excel, excel function, excel portfolio, integration php api, excel macro row

Om arbejdsgiveren:
( 10 bedømmelser ) Sydney, Australia

Projekt-ID: #977504

Tildelt til:

telemarketing555

Hi. Thanks for the invitation. Please check your PM. Thank you.

$250 USD in 7 dage
(26 bedømmelser)
4.4

4 freelancere byder i gennemsnit $375 for dette job

trivietsales

Hi, Please check PMB for details. Thanks, trivietsales

$500 USD in 10 dage
(16 bedømmelser)
5.5
vbexcel

Excel expert - ten years experience.

$250 USD in 7 dage
(26 bedømmelser)
5.3
kemlatak

For thousands of process in second would be hard to implement if we use pure Excel VBA using the API. I prefer to combine it with an excel plugin/addin which will use Lindo as well. The plugin will use thread method so Mere

$500 USD in 5 dage
(4 bedømmelser)
3.3