does sterling have built-in strategies and / or allow for strategy import? I am interested in converting some of my old-school spreadsheets and was wondering if it was an available feature. Also, does it have any form of strategy creation utility, etc.? TIA
They donât have any built in strategies like Tradestation. They have sample projects that they created to show you how to use the code and place a simple order. You have to build your own strategy and code using Excel VBA or build your own application with code using VB6 or whatever you use.
I am using Visual Studio 2008 to write to the Sterling API and I cant get any price quotes or send orders. I installed .net framework 1.1 (as Terry suggested) and my front end Sterling Trader is working fine. But I just cant get the API to work even with their demo programs. I keep getting a COM error. I even tried installing everything in another machine with Visual Studio 2005 and there I get these errors: A first chance exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll A first chance exception of type 'System.FormatException' occurred in mscorlib.dll Obviously I have asked Sterling support for advise but they havent been able to help. Did anyone else have the same issues? Any help would be really appreciated.
did the installation complain about any dll's not registering? There will be issues if any of the dll's do not register... Hope that helps, richardm
Hi, I hope someone here can help me out with the following problem: I am developing my porogram in Excel using VBA as my programming enviroment. I hava a Request Market Data button that when pressed runs the following procedure: ---------------------------------------------------------------------- ' request market data Sub RequestMarketData_Click() Dim id As Integer Dim Symbol As String Dim excahnge As String For Each Row In Selection.Rows id = Row.Row Symbol = UCase(Cells(id, Columns(COLUMN_SYMBOL).column).value) exchange = UCase(Cells(id, Columns(COLUMN_EXCH).column).value) If Cells(id, Columns(COLUMN_SYMBOL).column).value <> STR_EMPTY Then ' Register Quote Call ojSterlingControl.m_contractInfo.RegisterQuote(Symbol, exchange) ' update status column Cells(id, Columns(COLUMN_STATUS).column).value = STR_QRegistered Else MsgBox (STR_SYMANDEXCHMISSING) ' update status column Cells(id, Columns(COLUMN_STATUS).column).value = STR_ERROR End If Next ActiveCell.Offset(1, 0).Activate End Sub ------------------------------------------------------------------- The following is my event procedure to gather the information about the quotes: --------------------------------------------------------------------- Private Sub m_contractInfnSTIQuoteSnap(structQuoteSnap As SterlingLib.structSTIQuoteSnap) Dim i As Integer For Each Row In Selection.Rows i = Row.Row Cells(i - 1, Columns(COLUMN_BIDPRICE_Tickers).column).value = structQuoteSnap.fLastPrice Next End Sub ---------------------------------------------------------------------- When I select only one stock I get the quote data for it without any problem. Example *=Selected Before calling the Request Market Data Symbol Price C* F After Symbol Price C* 3 F If I select two or more stocks in the list I get the same Quote data registered for both symbols: Example Before Calling the Request Market Data Symbol Price C* F* After Intermediate Result Symbol Price C* 3 F* 3 Final Result Symbol Price C* 10 F* 10 So, both symbols get registered correctly but the event prints the same quote(price) data in all the price fields for all the symbols. So what I get is the price of the last stock in the symbol printed fo all the stocks in the list. I have tried different combinations of loops, also I tried using an array but I had no improvement. I hope someone here can point me towards the rigth direction as I would like to be able to select a range of symbols, call my request Data market procedure, and get all the quote data at once instead of going one by one through the whole list of stocks. ----- If I had more time this post would be shorter.
I was informed today that Sterling's API does NOT support Level 2 data. So the data you guys are piping into your own apps, does not include Level 2. Do I have that right?