Search results

  1. F

    Where can I get free data?

    Hi, I'm testing OpenTick data. They are quite reliable but I got the following problem with Futures Tick prices. During trade break they always transmit some <b>Ticks with size zero</b>, for example the EURUSD yesterday: ----Date--- -UtcTime -price -size volume 2007-03-22 23:30:06...
  2. F

    The Neuimex case

    Nice story. Would like to refer to it in our discussion thread on swiss forex brokers. Could you give some references and links verifying your story. Regards Martin
  3. F

    The Neuimex case

    In the meantime a customer involved in the Neuimex case with a considerable amount reported, that he got trustworthy insider information that the investigation probalby will lead to a positive result for Neuimex and its customers. So there might be hope Regards Martin
  4. F

    The Neuimex case

    Hi virgin, it seems they lost that stuff what's mentioned by your name :D ------------------ Their own explanation was as follows: <b>Neuimex</b> email 14/02/07 -> Customers Dear Customer, Neuimex Asset Management AG is currently undergoing an unannounced investigation by the...
  5. F

    The Neuimex case

    The Forex Broker 'Neuimex' based in Switzerland ist undergoing an official investigation. During investigation funds are freezed, but customers are offered to close their trades at market. First results are expected beginning of March at the earliest. See thread 'Neuimex Übersicht' or...
  6. F

    Interactive Brokers Excel Real Time

    Each connection to IB TWS needs to have a different ClientID. So typing a different number into the ClientID Cell sometimes may help - see screenshot
  7. F

    Interactive Brokers Excel Real Time

    Hi marklc, to understand what's meant by 'spreadsheet falls over' screenshots are needed. In most cases the spreadsheet doesn't seem to make problems. The Bar and the Stock-Version have been downloaded over 200 times until now, and only an handful problems habe been reported. Did you try the...
  8. F

    Interactive Brokers Excel Real Time

    Hi Grant, unfortunately it isn't. My Ticker uses the ActiveX-Control of IB to connect to TWS. This control communicates internally via Port Number XXXX with TWS, what opens the possibility to run TWS on a PC with IP XXX.XXX.XXX.XXX Port 7496 in China or your second PC while running my...
  9. F

    Interactive Brokers Excel Real Time

    When I should add backfill to my ticker, where storing historical data? What databank woud you prefer? MDB with Access2003 MDB with Access97 SQL Express with netFramework MySQLRegards Martin
  10. F

    Interactive Brokers Excel Real Time

    Hi Nick, I saw some of 5pilliars screenshots, with bars showing MarketDeltaColorLevels. The problem with MarketDelta to my opinion is that MarketDelta never is going one way only. It's always both some buying at the ask and some selling at the bid. Which direction is stronger, that's...
  11. F

    Interactive Brokers Excel Real Time

    I think about adding historical backfill to my ticker. Downloading historical data from IB is possible for example via ActiveX-VBA-requestHistoricalData-Method - see screenshot attached. But using this method, quickly you get a huge amount of data, possibly too much for Excel. Maybe storing...
  12. F

    Interactive Brokers Excel Real Time

    Hi Jonny, attached a screenshot of DebuggingVersion 2,041. If you got problems first hit 'Connect' and 'StopConnection' several times, after clicking away the error message. If the error doesn't disappear, please post a screenshot with the debugging message. Regards Martin
  13. F

    Interactive Brokers Excel Real Time

    Hi Jonny, attached the test version 2,041 with 'your' lines commented out. Probably the error will occur somewhere else now. Feel free to report new jpg's. Regards, Martin
  14. F

    Interactive Brokers Excel Real Time

    Here a screenshot of a possible real time screen with additional MarketDelta information color coded.
  15. F

    Interactive Brokers Excel Real Time

    Hi Nick, one day perhaps I'll give it a try. But it seems to be a lot of work and I doubt if it's worthwhile. Speaking of Futures, until now not even simple bid/ask information is fully used. So my dream just now would be to work out bid/ask information to a kind of real time MarketDelta...
  16. F

    Interactive Brokers Excel Real Time

    Hi jd conner, you can type in an individual date of expiry to each instrument, see screenshot attached. Individual data should overwrite default value which is programmed to take automatically the next 03/06/09/12 month. Regards Martin
  17. F

    Interactive Brokers Excel Real Time

    Hi Jonny, sure would I, but probably you didn't succeed uploading your jpg. Even had a look into my PMs but couldn't find any message with jpg attached. So please try uploading your jpg again. Regards, Martin PS Did you try to connect and disconnect several times? That's often the best...
  18. F

    Collect intraday data from IB

    To get 'your' quote you have to input the appropriate parameters into spreadsheet 'Basis'. Attached a working result.
  19. F

    Collect intraday data from IB

    Hi Jan, I wrote a Stock-Version for you, you can download here. There you'll find an explanation how to change the number of rows saved too. Enjoy Martin
  20. F

    Interactive Brokers Excel Real Time

    To change the number of rows saved you have to open VisualBasic Editor with 'alt+F11'. Then goto Module 'ModuleTWSapi' to Sub 'ListeSchieben' and change the copy range 'Range("A11:C1009")'. Regards Martin
Back
Top