API Support Forum
General > Feedback > Excel DDE
Author Topic: Excel DDE
(18 messages, Page 1 of 1)
Moderators:
estrader
Posts: 55
Joined: May 04, 2007


Posted: Aug 06, 2007 @ 01:41 PM             Msg. 1 of 18
Where can I download the Excel sample?
RVinicky
-Administrator-
Posts: 55
Joined: Jan 26, 2007


Posted: Aug 06, 2007 @ 01:50 PM             Msg. 2 of 18
Link to the page:
http://www.openecry.com/traderstoolbox/exceldde.cfm

Link to the userguide on the above page:
http://www.openecry.com/includes/pdf/DDE.pdf

Link to the add-in on the above page:
http://www.openecry.com/includes/exe/OEC%20Excel%20Add-In.exe

Note:
Microsoft® Excel 2003 has a bug that does not allow Microsoft® Excel Add-In's to load. Before installing the OEC Trader Microsoft® Excel Add-In the user should update Microsoft® Excel 2003 via "Microsoft Update" site or download and install the Update for Office 2003 (KB907417) http://www.microsoft.com/downloads/details.aspx?FamilyId=1B0BFB35-C252-43CC-8A2A-6A64D6AC4670&displaylang=en.

Robert Vinicky
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Sep 22, 2009 @ 07:51 AM             Msg. 3 of 18
Quote: Note: Microsoft® Excel 2003 has a bug that ...


Is this requirement right only for Excel 2003 and .Net 2.0 combination?

I still use Office 10 (aka XP, aka 2002) SP3 and .Net 2.0 SP1.
Need I anymore else for correct DDE functionality?
RVinicky
-Administrator-
Posts: 55
Joined: Jan 26, 2007


Posted: Sep 22, 2009 @ 09:22 AM             Msg. 4 of 18
2003 and above is what is supported by OEC.

Robert Vinicky
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Sep 22, 2009 @ 03:34 PM             Msg. 5 of 18
Thank you, Robert.

In other words, I must to upgrade my Office to 2003 at least?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua
RVinicky
-Administrator-
Posts: 55
Joined: Jan 26, 2007


Posted: Sep 22, 2009 @ 03:41 PM             Msg. 6 of 18
Chen,

Our Support Reps will not be able to assit you with any problems or issue you encounter if using this version.

In other words, if the problem is specific to OEC Trader, OEC will provide support. If the problem is a result of the combination of the operating system and the program, Office 2002, that particular problem will not be supported.

Microsoft stopped offering mainstream support for Office XP on July 11, 2006. They only support this product if you have some extended support package with them.

http://support.microsoft.com/gp/lifeoffice#Office

Please let me know if you have any further questions.

Regards,


Robert Vinicky
Edited by RVinicky on Sep 22, 2009 at 12:00 AM
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Sep 22, 2009 @ 04:08 PM             Msg. 7 of 18
I see, I see...

I'll be obliged to upgrade my Office to more fresh version soon. It's a great pity. Previous version suited me just fine.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Sep 22, 2009 @ 04:30 PM             Msg. 8 of 18
But now I have question that, I think, probably is not in direct relation on Office version.

Some time ago (on previous OECs before 3.4) I tryed to check DOM movies in Excel with simple
=UserName|DOM!ESZ9?price?0_Ask and _Bid
For more DOM deep view for highest Asks and lowest Bids I increment leading zero by 1 and get in Excel data pattern identical to OEC DOM screen.

Now, in case of Asks all it's fine. But, in case of Bids I get reversal pattern:
=UserName|DOM!ESZ9?price?0_Bid give me a lowest Bid in DOM.
And highest values (9, 12 or 14, for example), give me the first, highest Bid. I can't now - how many Bids are there and what Bid index correspond to highest, actual Bid, that form spread.

It's normal or wrong? Is it my old Office guilt?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Sep 22, 2009 @ 09:22 PM             Msg. 9 of 18
And now I have installed Office 2003 SP3 with mentioned KB923618.

Bids are reverse indexed...

http://piccy.info/view/d558520ee3950cd4029e8765fa36a163/

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia
RVinicky
-Administrator-
Posts: 55
Joined: Jan 26, 2007


Posted: Sep 23, 2009 @ 01:19 PM             Msg. 10 of 18
We will look into this for you.

Robert Vinicky
VictorV
Posts: 746
Joined: May 08, 2007


Posted: Sep 23, 2009 @ 01:27 PM             Msg. 11 of 18
The bug has been fixed. The bugfix will be available in the next build of Trader.
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Oct 21, 2009 @ 03:24 PM             Msg. 12 of 18
Thank you very much. I confirm that bug is fixed. DOM BIDs are in correct sequence now.

However the next bug(?) founded:

I enter the following formula: =UserName|tik!'6BZ9?Bid'
and get: "Unknown column: BID"

Sometimes "Bid" in formula automatically transforms to "BID". Trying to change transformed "BID" to "bid" or "Bid" by hands give no result.

Trying to get this formula in "Sample Add-In Book.xls" give me the same error.

'Ask' and 'Last' are working normally. Other symbols that I try are calculated normally too.
.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Oct 27, 2009 @ 03:40 AM             Msg. 13 of 18
Thank you for the attention given to my problem...



- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia

Edited by CChen15 on Oct 27, 2009 at 03:41:35
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Oct 30, 2009 @ 02:49 AM             Msg. 14 of 18
Is forum working or not?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia
RVinicky
-Administrator-
Posts: 55
Joined: Jan 26, 2007


Posted: Oct 30, 2009 @ 07:41 AM             Msg. 15 of 18
Chen,

This forum is meant for specific questions about the OEC API.

For the Excel DDE questions you have posted lately, it would be best if you requested assistance from our Support department (support@openecry.com). They would be a much better resource to assist you. I have forwarded this thread to them and they will get back with you on this.

Regards,

Robert Vinicky
CChen15
Posts: 121
Joined: Jul 23, 2009


Posted: Oct 31, 2009 @ 12:25 AM             Msg. 16 of 18
Sorry, Robert. However not I was treadstarter... I continue existing tread only.

I already recieve reply from Derek. Thank you for forwarding.

So, all questions re OEC Trader and DDE must be addresse to support@openecry.com? Is there any active users forum?
.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Chen Hua, Russia

Edited by CChen15 on Oct 31, 2009 at 00:26:42