FORUMS BROKERS SOFTWARE
Home
 
    Forums > Technically Speaking > Programming > DDE, Win7, OpenOffice, ThinkOrSwim


Reply
 
Thread Tools
Old Apr 16th, 2012, 12:42 AM   #1
bidforspu
 
 
Join Date: Jul 2010
Location: NYC
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...
    Quote
Old Apr 16th, 2012, 04:06 AM   #2
ddouglas
 
 
Join Date: 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).
    Quote
Old Apr 16th, 2012, 04:43 AM   #3
EEUT84
 
 
Join Date: Jul 2006
Posts: 51
Start -> run -> cmd

taskkill /f /im rundll32.exe <enter>
    Quote
Old Apr 22nd, 2012, 11:02 PM   #4
syswizard
 
 
Join Date: Jun 2004
Location: PA
Posts: 3,988
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.
    Quote
Old May 7th, 2012, 09:54 AM   #5
Derrick1983
 
 
Join Date: Apr 2008
Posts: 344
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/...hp?f=9&t=50494
Quote:
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).
Seems ddouglas was correct, as below link says the exact same reason:
http://forums.techguy.org/business-a...hink-swim.html
Do let us know if you solved the issue and how?
    Quote
Old Oct 20th, 2012, 08:26 AM   #6
bidforspu
 
 
Join Date: Jul 2010
Location: NYC
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.
    Quote
 
Reply
Thread Tools

Forum Jump



   Conduct Rules   Privacy Policy   Sitemap Copyright © 2014, Elite Trader. All rights reserved.   

WHILE YOU'RE HERE, TAKE A MINUTE TO VISIT SOME OF OUR SPONSORS:
Advantage Futures
Futures Trading & Clearing
AMP Global Clearing
Futures and FX Trading
Collective2
Automated Trading Services
CTS
Futures Trading Software
dom993trading.com
NinjaTrader Consulting
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
NinjaTrader
Trading Software Provider
optionshouse
Option Trading & Education
Rithmic
Futures Trade Execution Platform
SpeedTrader
Direct Access Trading
SpreadProfessor
Spread Trading Instruction
thenut-trader.com
FX, Gold, & Stock Signals
TradersStudio
System Building & Backtesting
Tradier
Equity and Options Trading
Trading Technologies
Trading Software Provider