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.

Evner: 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, www excel, works need excel, metatrader to excel, example of portfolio, article about visual basic, lindo api manual, excel lindo excel, excel metatrader, metatrader excel, what is macro in excel, simple api work, multicharts, metatrader c

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

Projekt ID: #977504

Tildelt til:


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

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

4 freelancere byder i gennemsnit $375 på dette job


Hi, Please check PMB for details. Thanks, trivietsales

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

Excel expert - ten years experience.

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

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 Flere

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