Registered: Jul 2010
Posts: 4

So I've been using OpenOffice Calc on my Windows XP Pro (SP3) machine for years. I've been getting real-time market data through DDE from ThinkOrSwim desktop to my OO Calc spreadsheet. Things have been great.

Now for some reason I thought it'd be a good idea to move on to Windows 7 64-bit, for more ram. I did a clean install of Windows 7 64-bit, and reinstalled TOS and OpenOffice Calc.... but no DDE works. I just get #N/A!

It seems to work with Excel, however. But for whatever reason, the DDE formulas in Excel are all static, I can't reference other cells. It's the strangest thing.

Is anyone running DDE links with OpenOffice or Excel in Windows 7 successfully? If so, how are you doing it?

Thanks. I might have to just reinstall Windows XP again. This is just terrible...

Registered: Aug 2011
Posts: 89

Do you have Google Chrome running?

I have TOS running on Windows 7, and Chrome will block the DDE - but it works fine as soon as Chrome is closed (no re-start or anything).

Registered: Jul 2006
Posts: 50

Start -> run -> cmd

taskkill /f /im rundll32.exe <enter>

Registered: Jun 2004
Posts: 3610

This is such total B.S. Has anyone contacted Google about this problem with Chrome ? To me, given their stellar reputation for only hiring the best and the brightest, might this not be INTENTIONAL ?
GOOG hates MSFT...that is known.
GOOG hates ORCL...read the papers.
GOOG hates anyone who gets in their way.

Registered: Apr 2008
Posts: 303

Maybe you can try the forum at: http://user.services.openoffice.org/en/forum/index.php
Some related topics are: http://user.services.openoffice.org...f=9&t=50494

---

Quote from ddouglas:
Do you have Google Chrome running?
I have TOS running on Windows 7, and Chrome will block the DDE - but it works fine as soon as Chrome is closed (no re-start or anything).

---

Registered: Jul 2010
Posts: 4

I couldn't get OpenOffice Calc to work with ToS DDE even when shutting down Chrome. But I didn't really like that solution because I use Chrome a lot.

I searched and searched and even ended up paying for livevolpro to get my market data into Excel. But that was way too expensive.

Finally I found something called XLQ. It's a neat little program that allows you to get real-time (if you subscribe to a source that provides real-time, such as TD Ameritrade or IB) and historical market data into Excel using RTD-like formulas. Best of all (as opposed to ToS DDE) the formulas allow for cell references.

I'm also able to get some technicals streaming into Excel too, which is really helpful.

The program is not free, but seems pretty reasonable to me.

Anyway, thought I'd share. I've only installed it this weekend, so I haven't seen it working when the markets are open. So far so good though.

Advantage Futures

Futures Brokerage & Clearing

AMP Global Clearing

Futures and FX Trading

Bright Trading

Professional Equities Trading

CTS

Futures Trading Software

DaytradingBias.com

Professional Trading Analytics

ECHOtrade

Professional Trading Firm

eSignal

Trading Software Provider

FXCM

Forex Trading Services

Global Futures

Futures, Options & FX Trading

Interactive Brokers

Pro Gateway to World Markets

JC Trading Group

Direct Access Trading

MB Trading

Direct Access Trading

MultiCharts

Trading Software Provider

NinjaTrader

Trading Software Provider

OANDA

Currency Trading

optionshouse

Option Trading & Education

Rithmic

Futures Trade Execution Platform

SpeedTrader

Direct Access Trading

SpreadProfessor

Spread Trading Instruction

thinkorswim by TD Ameritrade

Direct Access Trading

TradersStudio

System Building & Backtesting

Trading Technologies

Trading Software Provider

Trend Following

Trading Systems Provider