Hi,

I need some help, please, calling Excel functions using data already in TradersStudio arrays.  I think I have seen example of passing arrays/ranges back and forth between Excel and TradersStudio (ie if you know the exact start and end cells on an Excel worksheet)

However, I am wondering if you can call an Excel function (say LINEST for example) using data already in TradersStudio, and then explicitly pass that result back into TradersStudio.  Can you please provide an example of that please?  In Visual Basic, I think you can do something like the following:

Set myRange = Worksheets("Sheet1").Range("A1:C10")
answer = Application.WorksheetFunction.Min(myRange)

So how can I explicitly call an excel function from within TradersStudio, as the 2nd line does from within Visual Basic?  Thanks!

Regards,

Scott

XLGetRangeValues(Worksheet, Row1, Col1, Row2, Col2) As Variant

This function will return the range value to you. You need to process the data in the DLL directly for your calculations. We did not add a way of calling Excel Functions. We can call Macros from Excel.