Search results

  1. C

    IB Excel Sheet: Overflow

    Finally have it working. The below works for me. installed API beta 9.1 uninstalled TWS Deleted the JTS folder and installed TWS 868 (march 06 2007) new install. TWSDDE.xls changed value from 1000000 to 100000.
  2. C

    Submit Orders to IB through Excel

    Just to clarify. Are you saying that you changed "DAYS_PRIOR_TO_DDE_API = 37000" to "Const DAYS_PRIOR_TO_DDE_API = 39000" (posted by users as a fix in the ib forums) and now you submit orders without the overflow message, but the orders are wrong/partial? If so I have some...
  3. C

    Spydertrader's Jack Hershey Equities Trading Journal III

    Although, I don't use quote tracker I experience the same problem with IB's charts regarding volume discrepancies. I am pretty sure that: 1. The bad volume occurs only when live data is passed to the chart. (I am going to guess that your quotetracker bad volume would also match the bad...
  4. C

    Spydertrader's Jack Hershey Futures Trading Journal

    Here are my results (real time trades but in an IB simulated account). The little blue things are Buys, maroon = sells. (I took a long lunch and missed part of that major down move.)
  5. C

    Spydertrader's Jack Hershey Equities Trading Journal III

    This is an update of the earnings.xls file that I uploaded yesterday. There was an issue with hidden instances of IE not being closed properly which resulted in high memory usage both during and after running the "get earnings" procedure.
  6. C

    Spydertrader's Jack Hershey Equities Trading Journal III

    If you would like to change the workbook name without messing up the macro. 1. (close all open Excel Workbooks). Open Earnings.xls 2. Press ALT F11 (hold down ALT key then press the F11 key) 3. (visual basic window opens) Click EDIT>Replace 4 Find What: Earnings.xls Replace...
  7. C

    Spydertrader's Jack Hershey Equities Trading Journal III

    I have updated my earnings.xls spreadsheet to parse for an earnings date from Zacks.com, (in addition to clearstation and yahoo). The dates are automatically (but slowly) filled in and placed side by side so that you can compare the earnings dates given by the different sources. The point...
  8. C

    Spydertrader's Jack Hershey Equities Journal II

    Yahoo shows CBEY earnings date was Nov 1 (and has the <a href="http://biz.yahoo.com/bw/061101/20061101006045.html?.v=2">report</a> available to read). I have noticed a lot of symbols lately showing recently reported on yahoo while CS shows a soon but future date. Yahoo seems to be the more...
  9. C

    Spydertrader's Jack Hershey Equities Journal II

    If you want to use 3 months to calculate DU in volume scan version 1.0 you can change AVERAGEDU:= (DU1+DU2+DU3+DU4+DU5)/DIVIDEBY; to AVERAGEDU:= (DU1+DU2+DU3)/3;
  10. C

    Spydertrader's Jack Hershey Equities Journal II

    Although, I realize that you might like to let recently ranked stocks hang around for a bit, there is a software program called "automate" that I use to open wealth-lab and run du/rank scans automatically every night. It's very user friendly and the learning curve is very very short. You do...
  11. C

    Spydertrader's Jack Hershey Equities Journal II

    I think without realizing it you have given a nice description of peak Volume (often signaling cycle end.)
  12. C

    SCT High Velocity Profits Q and A Journal

    File>Print Preview - (then at top you have options to "shink to fit" or scale down)
  13. C

    Interactive Brokers DDE EXcel file questions

    If it seems complex, just focus on undertanding the quotes sheet and the order sheet. (I just ignore the existing conditional sheet, since it never really made sense to me) Then just create your own new sheets For example a "Buy" sheet and a "sell" sheet. lay them out however you want...
  14. C

    Spydertrader's Jack Hershey Equities Journal II

    Yes, it should fill in just like the yahoo column. Try it again and let me know if there is still a problem with the Clearstation column filling in. Once Yahoo is complete, it could pause for up to 15 seconds or so before clearstation gets going (I just tested it again and it all works here)
  15. C

    Spydertrader's Jack Hershey Equities Journal II

    Hopefully this will work for you! I created this excel file that parses Clearstation and yahoo. I figure that everyone is pretty familiar with excel and knows how to import into it. Also, I think I laid it out in such a way that you can customize it to your liking pretty easily. I think I...
  16. C

    Trouble interpreting price and volume

    This is just the way I see it. I have learned to focus less on each individual bar and more on the last few. Forest instead of the trees.
  17. C

    IB TWS Build 860 - Solictation of interest.

    I learned the hard way, to wait a few days whenever a new TWS is released. The problems with this mornings release were apparently severe enough that they removed the upgrade.
  18. C

    Spydertrader's Jack Hershey Equities Journal II

    With very little wealth lab skills, I am trying to create a scan for Negative Price Derivitive AND Negative Volume Derivitive by editing the trading rules in Hershey Equities Rank v. 4.0.0 Hopefully others would be interested in this scan. Usually the scan result would be stocks pulling back...
  19. C

    Spydertrader's Jack Hershey Equities Journal II

    ESCL was in my Ranked list. I have never traded it but WOW, down -61.78%. It's a good reality check of what can happen on terrible news I suppose. "On May 9, 2006 it was publicly reported that Spanish police had made arrests and raided the offices of Afinsa and the Company's offices in...
  20. C

    Spydertrader's Jack Hershey Equities Journal II

    Clearstation shows that TFSM reports earnings tomorrow.
Back
Top