Quantcast
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Kevin Lee
Last Activity:
Nov 17, 2017 at 6:57 PM
Joined:
Jun 2, 2014
Messages:
396
Likes Received:
686
Trophy Points:
93
Gender:
Male
Birthday:
October 13

Share This Page

Kevin Lee

Well-Known Member, Male

One other thing you might want to check. OV with DDE link to TOS might also cause VBA with TOS DDE to crash. Dec 28, 2015

Kevin Lee was last seen:
Nov 17, 2017 at 6:57 PM
    1. Kevin Lee
      Kevin Lee
      One other thing you might want to check. OV with DDE link to TOS might also cause VBA with TOS DDE to crash.
    2. Jay Hattler
      Jay Hattler
      Thank you very much, Kevin, for the confirmation. I'll work on it some more. Jay
    3. Jay Hattler
      Jay Hattler
      Kevin, I reference your note (#47 in the thread) : http://forums.capitaldiscussions.com/threads/m3-trade.103/page-3

      You describe storing BF prices. I use Excel/TOS to calculate prices. But how do you save them "every 5 minutes"? I tried the VBA Application.OnTime function to copy every so often. But the code stops when I run this in the background and still use my laptop for other things. Can you advise?

      Jay
      1. Kevin Lee
        Kevin Lee
        Hi Jay,

        I'm using the Application.OnTime function too. It works.

        I only get problems when I tried loading multiple months on RUT, SPX, NDX etc... on the same spread sheet. Excel will crash after a while. Now I only capture 2 months RUT only.

        Try googling to see if you can find solutions. If you want me to test your code, send it over.
        Dec 26, 2015
        jerrymattx likes this.
  • Loading...
  • Loading...
  • About

    Gender:
    Male
    Birthday:
    October 13