Search results

Version 2,04 the Stock-Version of my Excel-Ticker-Spreadsheet.

Hi Herry, it is possible But to get rid of these data crippling candlesticks that's just the reason I'm programming a real time solution. Nevertheless, I wrote a new version with English manual for you. To see the new spreadsheet in action have a look at the attached video. Regards...

The run-time error often occurs when VBA want's to write into a spreadsheet cell, which you happened to select manually. So try to set the cursor into an empty cell and connect again. Hope that helps. In the meantime a wrote another version charting minute bars too, you find it in this...

The Excel-Ticker spreadsheet.

The manual for Excel-Ticker spreadsheet.

The video of the spreadsheet working. Download and open in MediaPlayer. You needn't to unzip it, if you like simply delete the '.zip' ending.

Would like to discuss development of software processing TWS quotes real time in Excel. Starting with a pre production version (v2,03) of my Excel-Ticker, see screenshot below. Following soon: video: Ticker_2,03inAction.avi.zip manual: ManualExcelTWSv2,03.pdf spreadsheet...

yeah - Hi Henry - I wrote that zero version piece of software for a German discussion group, so the manual is in German too, but it has got a lot of screenshots, so it might be helpful even though you don't understand the text. Development goes on - just working on a professional looking real...

Wouldn't 1 minute bars be better? - Think there are a lot of programs to create 5min bars out of 1min data, but the other way round it's impossible, since 1min data are lost in longer time frames.

it is! Have a look to thread 'Tick by Tick data on TWS'. There you can download the zero version of my spreadsheet 'excel-twsv2,01.xls' and the correspondent manual It's purpose is to chart one instrument of IB in realtime. To fulfill this task a table is filled with realtime data row by...

Own code could be interesting for testing, comparing and perhaps even realizing own trading ideas. What data feed do you plan to base your code on?

You are right, Henry, until now IB delivers data bars without low and high. They call it 'snapshot' taken every 0.2 to 0.3 seconds. But IB accepted improvement proposal number 1035 of kiwi_trader, so there might be hope that we'll get additional high and low soon. With real high and low...

5pillars and e-miNY you posted very interesting screenshots of MarketDelta screens. And you, 5Pillars, stated that MarketDelta needs a tick by tick data provider. So I would like to know what's your data provider and what are your experiences during news times? Are MarketDelta results...

What do you think of Marketdelta, Tradeflow and UpTick? - Would it be worthwhile to compute and chart similar data? And what's your experience with IB TWS based services like MarketDelta-IB? Do they produce useful results even if based on the IB 0.3 second snapshot data, so that it should be...

Hi Nick, with latest VisualStudio2005 you really can do great things. And instead of costing hundrets of Dollars for earlier versions it's even free (ExpressVersion). Nevertheless I think it's not advisable to learn that new stuff for a trader. Versions too often change so you keep...

As promised in my previous posting here the ZeroVersion 2,01 of my ExcelTicker.

Hi Nick, you are right, IB's sample spreadsheet is based on DDE and not on ActiveX. And using their other examples first you have to learn an outdated version of Visual Basic, either old day VB6 or VB_Net of 2003, both a big waste of time if you don't want to become a professional...

Attached find the manual mentinoned in my previous posting. On side 3 and 4 you find explanation how to get the activeX control working in Visual Basic. It's in German but with screenshots so I hope it's understandable. Regards, Martin

Hi stock777 I thought your 'trade sweeps' problem would just be the 'lacking High/Low' problem, for example: time Volume@Price (+High Low if happened) reported by IB: xxx:21,263 10,010@35.40 ----------- xxx:21,289 10,025@35.40 xxx:21,308 10,525@35.50 xxx:21,336 10,535@35.50...

If interested in code producing an earlier version of the chart posted above have a look here.