Search results

  1. syswizard

    Is Autotrading the solution to our psychological trading pain?

    It's tricky business. One should compare semi-auto results with full-auto results to see if the discretion is "working".....and that the trader's intuition is better than the machine's.
  2. syswizard

    Is Autotrading the solution to our psychological trading pain?

    re: "sweet spots" - you mean support and resistance levels or pivot points or what exactly ?
  3. syswizard

    Is Autotrading the solution to our psychological trading pain?

    Correct. The semi-auto approach can be very dangerous....as it can then veer from the backtested results. On the other hand, a well-seasoned trader with tons of experience with the algo, might actually be able to improve the performance thru intuition, etc.
  4. syswizard

    Is Autotrading the solution to our psychological trading pain?

    Dude - One YEAR ??? This tells me you don't know how to "cut your losses". I was dating a woman like this and she behaved similarly....very, very cheap. Then I discovered she's making more money than me !! I was gone before the end of 6 months. As far as vagina.....I never even saw it....that...
  5. syswizard

    Is Autotrading the solution to our psychological trading pain?

    My feelings exactly. You can set it up as fully auto or semi auto where the trader is notified of the trade opportunity and then decides on his own whether or not to take it.
  6. syswizard

    Should I move to Tradestation ?

    The developers of the initial release got PO'd and left the company. As tons of bugs started to surface, they brought in a consultant to look at the internals of the application, mainly the coding. When he saw what a mess it was, he made this huge estimate of the cost to repair it. That's when...
  7. syswizard

    SQL for this query ?

    IMHO: false allegations.... 1) re:"overlooked important points"....and so you don't enumerate them in this thread ? What a load of B.S. that is ! 2) re: "I posted that solution to the public domain"....and so you provided no link ? What a load of B.S. that is ! 3) Finally, the "key" to this...
  8. syswizard

    Should I move to Tradestation ?

    Thanks Fonz for that valuable feedback !! Which data subscriptions are you using with IB/Multicharts ? For me, it's looking like sticking with DTN IQFeed is the best way to go......too costly for professional data subscriptions on IB. More importantly, DTN has historical data in TICKS....as my...
  9. syswizard

    SQL for this query ?

    Drat - a clever programmer can abstract this problem to work BOTH WAYS. And that's what I intend to do. This particular example is only the swing-low counts......the other would be the swing-high counts. The real challenge here is doing BOTH WAYS in a single pass of the source data...
  10. syswizard

    SQL for this query ?

    I do have it defined....especially since I've provided the methodology. So if it's that easy Dude, why don't you write the code ?
  11. syswizard

    Should I move to Tradestation ?

    In contrast, I've been really impressed with Multicharts. Their forum and tech support is superb IMHO. Each new release seems to bring-out some issues, but they get resolved very quickly.
  12. syswizard

    SQL for this query ?

    re: "Basically, you need to define how a 'drop' both ends and begins." I understand that. I am still formulating the details. My gut is telling me that some implementation of the HIGHEST(CLOSE,nn) and LOWEST(CLOSE,nn) functions with a sliding date window is the way to go. Start with the earliest...
  13. syswizard

    Should I move to Tradestation ?

    Thanks guys for the feedback. It's pretty incredible to me that Tradestation's platform is not reliable or stable by now. After the TS2000i debacle where they couldn't fix it, one would have thought they have learned their lesson.
  14. syswizard

    SQL for this query ?

    -- LET'S SAY WE NEED TO LIST THROUGH ALL LAST NAMES AND PERFORM SOME ACTION -- ON LAST NAMES BEGINNING WITH THE LETTER S SELECT StaffId, LastName FROM Staff WHERE LastName LIKE 'S%' -- THIS RETURNS A SET AS SUCH -- StaffId LastName -- ======= ======== -- 11 Sherwood -- 35 Schmidt -- 41 Sauvé --...
  15. syswizard

    SQL for this query ?

    "Show me the code". Either T-SQL or PL/SQL would do fine. Cursorless would be preferred, but I am not sure it's possible.
  16. syswizard

    Should I move to Tradestation ?

    Been with Interactive Brokers for auto and semi-auto trading using Multicharts and DTN IQFeed. Why the feed ? Because of the exhorbitant data feed rates for corporate accounts at IB. The big problem is: without the IB data feeds, many resources on interactive are not operative....for example...
  17. syswizard

    SQL for this query ?

    Dude - you are just not "getting it"...or what ? Did you not read the caption of the chart that was linked ? It's a count of the number of downturns for a given symbol where there was a 10% percent or greater drop from the prior high point. GET IT ? This is a really interesting market stat - as...
  18. syswizard

    SQL for this query ?

    No it isn't. All you need is the close price data and a starting date. That's it. It could be 1/1/2000 or 10/1/2010. It's not straightforward, that's for sure. It may require a cursor, not sure. Still thinking about it.
  19. syswizard

    MCD - overdone on the upside ?

    Here we go with Mickey D's at all time highs. Looks to be parabolic on the chart...a good sign to go short. All of the bulls are "sucked-in"....and all shorts have covered.
  20. syswizard

    SQL for this query ?

    So the S&P 500 is at 2000 on Jan 1st, it then goes down to 1800 on April 1st. So (2000-1800)/2000 is 10%. Now we have a potential event for the chart. Then we count the number of trading days between the two dates. The important issue is that the 1800 represents the bottom before the next 10%+...
Back
Top