Programmable real-time market scanner

Discussion in 'Trading Software' started by I$land, Jul 19, 2007.

  1. [I never could get Neoticker's scanner to work. I spent all my time refreshing the data.

    Tradestation is the only option that I am aware of that works and is what I use.

    The only problem with Tradestation is it can only scan one time frame at a time unless you set up another page in Radarscreen.

    For instance, if you wanted to scan 500 stocks on the daily, 15 min, 5 min, 2 min, you would have to set up 4 pages in Radarsreen.

    I just use the daily screens and have put in 700+ stocks with 15 columns of parameters using a old p-4 2.2 mhz machine that I bought in 2001 or so.

    John
     
    #11     Jul 19, 2007
  2. I$land

    I$land

    That’s great info John, thanks.

    RadarScreen looks like an amazing product but unfortunately I don’t think I will be able to use it. The reason is I would probably need to open an account with TradeStation and I don’t think that’s possible unless they recently changed their policy. I live in Canada and they don’t want us as customers :(

    Maybe I could use RadarScreen as a standalone app but I doubt it... ?
     
    #12     Jul 19, 2007
  3. just21

    just21

    #13     Jul 19, 2007
  4. I$land

    I$land

    just21 - Good stuff, looks like a powerful scanner.

    Thanks for the info.
     
    #14     Jul 19, 2007
  5. #15     Jul 19, 2007
  6. I$land

    I$land

    marketsurfer - I'm already a Trade-Ideas subscriber but I find it limited because you can only choose among the available options. I would like to code what I really want instead.

    I’m currently watching the tymoraPRO video (48 min long). This software definitely seems like it has some crazy features ! Wow, it really looks powerful.

    Excellent stuff, thanks !
     
    #16     Jul 19, 2007
  7. Wanted to resurrect this thread. I am looking for a new way to scan intraday (and EOD for that matter). At this time I don't need to scan for complex custom conditions - basically just want to know when price hits a certain level. I have an eSignal feed but I don't know what will happen if I have hundreds of stocks I want to scan and run up against eSignal's absurd symbol limits.

    Anyhow, I checked out Investor R/T. Seems like it could do what I wanted... eventually. Problem is, the learning curve seems real steep. For instance I checked out some of the tutorials at the website and apparently they were made in 2000!! They include screenshots of a way older version of the program and half the dialog boxes have changed.

    Point is, I think I would be on my own to learn it and it seems like there are a lot of things to learn.

    I need something simple for now. Really I just want to focus on the last price in any time frame.

    Any further comments or anyone have a program that's not in this this thread yet?

    Listed here so far have been

    TradeStation RadarScreen and WealthLab (no good, I don't want to open a brokerage account to get a screener)

    Investor RT

    Neoticker (I'll check it out next, comments appreciated)

    Neovest (looks serious but also looks expensive. No price at website = costly)

    Tymora (yourika) looks a bit weird, website has strangely worded descriptions and mentoring is advertised.

    Any other solutions? I just want an Excel type screen that lists all my stocks and gives me an audio alert when a certain price level is reached.
     
    #17     Dec 29, 2007
  8. That seems pretty straight forward...

    Why not have some VBA code do that inside an Excel Sheet that is being fed by a DDE feed or RTD feed...


    <img src="http://www.enflow.com/p.gif" >
     
    #18     Dec 30, 2007
  9. Yes, indeed. There seems to be a DDE setup available for eSignal. I'm waiting for the eSignal mods to approve my forums registration (48 hours!!) and then I am going to ask in there. I know this is lame but I'm not enough of a techie to know exactly what's necessary to code that up in VBA.

    So can you at least tell me this - the DDE part is the actual 'plug-in' that would allow Excel to be fed data, right? Dynamic Data Exchange allows different Windows programs to talk to each other, right? Then the VBA code tells Excel what to do with the data (play me a little sound when conditions are met, create the columns I need, etc). Is that accurate?

    If that's right then what I need is a bit of code that would convert the data coming from the DDE feed and instruct Excel, and the DDE feed itself which is a program? Or would the VBA code and my eSignal Real Time Feed potentially be good enough?

    Can you by any chance point me in the right direction for that code? Do I get some college kid to code it up for me?

    EDIT: Joined the Excel Experts Club at Yahoo groups, maybe they can help me out in there.
     
    #19     Dec 30, 2007
  10. Here is a complete sample of the windows Declare function for the VBA Timer event and the VBA code itself in three parts...

    GIVE THIS TO A YAHOO GUY/GROUP WHO WANTS TO HELP YOU...

    What it can do is test a spreadsheet for price changes every whatever (x) seconds... and you can also have the VBA coder set off a wave file audio alert too... .mdw file


    Declares

    Public Declare Function SetTimer Lib "user32" ( _
    ByVal HWnd As Long, ByVal nIDEvent As Long, _
    ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long

    Public Declare Function KillTimer Lib "user32" ( _
    ByVal HWnd As Long, ByVal nIDEvent As Long) As Long

    VBA Timer Code...

    Sub StartTimer ()
    On Error GoTo Err_Prob

    TimerSeconds = 2 'pop the windows time every x seconds
    TimerID = SetTimer(0&, 0&, TimerSeconds * 1000&, AddressOf TimerProc)

    Exit_Err_Prob:
    Exit Sub

    Err_Prob:
    MsgBox Err.Number & " " & Err.Description
    Resume Exit_Err_Prob

    End Sub

    Sub EndTimer()
    On Error GoTo Err_Prob

    runTimer = False
    KillTimer 0&, TimerID

    Exit_Err_Prob:
    Exit Sub

    Err_Prob:
    MsgBox Err.Number & " " & Err.Description
    Resume Exit_Err_Prob

    End Sub

    Sub TimerProc(ByVal HWnd As Long, ByVal uMsg As Long, ByVal nIDEvent As Long, ByVal dwTimer As Long)
    On Error GoTo Err_Prob

    HAVE THE YAHOO GUY/GROUP DO THEIR CODE HERE TO TEST YOUR SYMBOLS FOR THE LAST PRICE VALUE...

    THAT IS QUITE EASY FOR EXCEL VBA CODER.


    'you also need error handling since pulling and pushing data burps once in awhile...

    Exit_Err_Prob:
    Exit Sub

    Err_Prob:
    If Err.Number = 55 Then
    'take some code action here...
    Resume Next
    Else
    Err.Clear ' Clear Err object fields
    Resume Next
    MsgBox Err.Description
    End If
    If Err.Number = 440 Or Err.Number = 432 Then
    'Tell user what happened. Then clear the Err object.
    MsgBox "There was an error attempting to open the Automation object!"
    Err.Clear ' Clear Err object fields
    Resume Next
    End If
    EndTimer
    StartTimer
    Debug.Print Err.Number & " " & Err.Description
    Resume Exit_Err_Prob
    End Sub

    You build a macro button on the front interface of Excel that calls the start timer event and a button that does the End Timer event and -- bada bing... you got a timing system...

    <img src="http://www.enflow.com/p.gif">
     
    #20     Dec 30, 2007