Universal DDE: ask and bid data are not collected, instead collects trade data multiple time - [OPEN] MC-2302

#1

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 11, 2017 - 17:42

star character must have some special meaning in this editor. It is missing in view.
There are * between ! and C above DDE items.

#2

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 11, 2017 - 17:44

A file was uploaded. excel_dde.zip

#3

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 11, 2017 - 17:46

A file was uploaded. DDE_Symbol_1.xlsx

#4

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 11, 2017 - 17:46

A file was uploaded. DDE_Symbol_2.xlsx

#5

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 11, 2017 - 17:57

A file was uploaded. ok_button5.wmv

#6

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 13, 2017 - 00:13

Currently, I think there's no way to make DDE symbol which collect trade, ask, bid and uses excel as DDE server.

I have one DDE symbol (named DDESymbol1) which was made with version 11 beta 2 which use excel as DDE server.
In this version, it still works fine, collecting trade, ask, bid.

I followed the same procedure I made DDESymbol1 for new DDESymbol3
The differences are,

when I click OK button of "Universal DDE" window,

version 11 beta 2: silent, no error popup, but does not close "Universal DDE window", can close window by clicking upper right X buton(window close button)
version 11 : error popup, looking for * in item name, ok to this popup, and close "Universal DDE window" by clicking upper right X buton(window close button)

when I click "connect symbol",

version 11 beta2: change to "ON"
version 11: this new symbol shows error pop up error message "Data feed could'nt be loaded.", but closing all MC application and restart can make this symbol On/Off as I selected.

Quote Manager Results are different

version 11 beta 2: collected ask, bid , trade
version 11: collected trade only

I would like to know if ther's workaround for making DDE symbol which use excel as DDE server and collect ask bid trade data.
If there's no workaround, then a patch or version 12 beta.

Info related to this problem.

https://www.multicharts.com/pm/public/multicharts/issues/MC-2293
https://www.multicharts.com/pm/public/multicharts/issues/MC-2303

Edit comment #6

Comment visibility (whether to hide this comment for "regular users")

Comment

Selected syntax: Markdown ▼

### Currently, I think there's no way to make DDE symbol which collect trade, ask, bid and uses excel as DDE server.
I have one DDE symbol (named DDESymbol1) which was made with version 11 beta 2 which use excel as DDE server.
In this version, it still works fine, collecting trade, ask, bid.

I followed the same procedure I made DDESymbol1 for new DDESymbol3
The differences are,

### when I click OK button of "Universal DDE" window,

**version 11 beta 2**: silent, no error popup, but does not close "Universal DDE window", can close window by clicking upper right X buton(window close button)
**version 11** : error popup, looking for * in item name, ok to this popup, and close "Universal DDE window" by clicking upper right X buton(window close button)

### when I click "connect symbol",

**version 11 beta2**: change to  "ON"
**version 11**: this new symbol shows error pop up error message "Data feed could'nt be loaded.", but closing all MC application and restart can make this symbol On/Off as I selected.

### Quote Manager Results are different

**version 11 beta  2**: collected ask, bid , trade
**version 11**: collected trade only

I would like to know if ther's workaround for making DDE symbol which use excel as DDE server and collect ask bid trade data.
If there's no workaround, then a patch or version 12 beta.

Info related to this problem.

https://www.multicharts.com/pm/public/multicharts/issues/MC-2293
https://www.multicharts.com/pm/public/multicharts/issues/MC-2303

Don't worry about URLs - they will automatically be transformed to links.
See more formatting tips in MarkdownFormatting.

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

You can use simple formatting tags for underlined text () or strikethrough ().
See more formatting tips in WikiFormatting.

or cancel

Reply to comment #6

Comment visibility (whether to hide this comment for "regular users")

Selected syntax: Markdown ▼

'''Khitan wrote:'''
>### Currently, I think there's no way to make DDE symbol which collect
> trade, ask, bid and uses excel as DDE server.
> I have one DDE symbol (named DDESymbol1) which was made with version 11
> beta 2 which use excel as DDE server.
> In this version, it still works fine, collecting trade, ask, bid.
> 
> I followed the same procedure I made DDESymbol1 for new DDESymbol3
> The differences are,
> 
> ### when I click OK button of "Universal DDE" window,
> 
> **version 11 beta 2**: silent, no error popup, but does not close
> "Universal DDE window", can close window by clicking upper right X
> buton(window close button)
> **version 11** : error popup, looking for * in item name, ok to this popup,
> and close "Universal DDE window" by clicking upper right X buton(window
> close button)
> 
> ### when I click "connect symbol",
> 
> **version 11 beta2**: change to  "ON"
> **version 11**: this new symbol shows error pop up error message "Data feed
> could'nt be loaded.", but closing all MC application and restart can make
> this symbol On/Off as I selected.
> 
> ### Quote Manager Results are different
> 
> **version 11 beta  2**: collected ask, bid , trade
> **version 11**: collected trade only
> 
> I would like to know if ther's workaround for making DDE symbol which use
> excel as DDE server and collect ask bid trade data.
> If there's no workaround, then a patch or version 12 beta.
> 
> 
> Info related to this problem.
> 
> https://www.multicharts.com/pm/public/multicharts/issues/MC-2293
> https://www.multicharts.com/pm/public/multicharts/issues/MC-2303
> 
> 
> 
>

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

The Bug Genie uses an enhanced flavor of the markdown syntax, which makes each newline count. If you want to add a linebreak, add a new line and it will be presented just like you type.
See more formatting tips in MarkdownFormatting.

To create a bulleted list, start one or more lines with a star ("* bulleted list item"). You can create a numbered list by using the hash/pund sign instead ("# numbered list item").
See more formatting tips in WikiFormatting.

or cancel

#7

MultiCharts Support (MultiCharts)

MultiCharts Support
Last seen online at Apr 17, 2024 - 12:37
Show user details

Aug 15, 2017 - 15:40

1. Only data, selected in the settings of the instrument is collected into the database. What you see in the Scanner columns (Ask and Bid) is the data from the Status Line, that is never saved in the database. In the database you see 3 ticks of Trade data only because your data is fed incorrectly by your application. We have tested it on our end and it collects only 1 Trade tick.
Collect real-time data in QuoteManager by enabling all the required fields:
https://www.multicharts.com/trading-software/index.php/Online_Mode_Data_Collection

2. "version 11 : error popup, looking for * in item name, ok to this popup, and close "Universal DDE window" by clicking upper right X buton(window close button)" - this issue was not reproduced on our end, please provide the exact steps. It might happen, if you closed MC and all its processes were ended before you run it again.

Edit comment #7

Comment visibility (whether to hide this comment for "regular users")

Comment

Selected syntax: Mediawiki ▼

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

If you have certain text you don't want to be formatted, enclose it in tags: "'''formatted''' text '''non-formatted''' text.
See more formatting tips in WikiFormatting.

or cancel

Reply to comment #7

Comment visibility (whether to hide this comment for "regular users")

Selected syntax: Mediawiki ▼

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

Don't worry about URLs - they will automatically be transformed to links.
See more formatting tips in MarkdownFormatting.

URLs will be automatically transformed to links. If you want to add a title, use the link formatter: [[http://awesome.com/something An awesome link]].
See more formatting tips in WikiFormatting.

or cancel

#8

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 16, 03:21, in reply to comment #7

I download test program and excel file from here and retested.

Two screen recording are attached. Repro1 shows detailed procedure and the result, collecting 3 times. Repro2 shows OK button is requesting * almost unconditionally.

There was my mistake of leaving "Fields to Collect" of Quote Manager as default. I configured it to collect Trade, Ask, Bid. The result was that it collected trade, ask, bid, but trade was collected 3 times, ask, bid the same. Trade price pair (R1C1, R1C2). Bid pair (R1C3, R1C4), Ask pair (R1C5, R1C6) in one sheet must have relation to this problem. If I put these pairs to different sheets of their own(sheet1, sheet2, sheet3 for Trade, Bid, Ask), then each collected 1 time.

I wonder if these behaviors are by design or bug. If it is by design, then documentation should include a statement, "When using excel as dde server, do not put pairs in one row, the only choice is put them in different sheet of same row, since Rn should be the same for Trade, Ask, Bid".

If OK button do not look for *, then I can name symbol whatever I want, and put pairs anywhere in the excel.

Edit comment #8

Comment visibility (whether to hide this comment for "regular users")

Comment

Selected syntax: Mediawiki ▼

I download test program and excel file from here and retested.

Two screen recording are attached.
Repro1 shows detailed procedure and the result, collecting 3 times.
Repro2 shows OK button is requesting * almost unconditionally.

There was my mistake of leaving "Fields to Collect" of Quote Manager as default.
I configured it to collect Trade, Ask, Bid.
The result was that it collected trade, ask, bid, but trade was collected 3 times, ask, bid the same.
Trade price pair (R1C1, R1C2). Bid pair (R1C3, R1C4), Ask pair (R1C5, R1C6) in one sheet must have relation to this problem.
If I put these pairs to different sheets of their own(sheet1, sheet2, sheet3 for Trade, Bid, Ask), then each collected 1 time.

I wonder if these behaviors are by design or bug.
If it is by design, then documentation should include a statement, "When using excel as dde server, do not put pairs in one row, the only choice is put them in different sheet of same row, since Rn should be the same for Trade, Ask, Bid".

If OK button do not look for *, then I can name symbol whatever I want, and put pairs anywhere in the excel.

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

To create a bulleted list, start one or more lines with a star ("* bulleted list item"). You can create a numbered list by using the hash/pund sign instead ("# numbered list item").
See more formatting tips in MarkdownFormatting.

You can create a link directly to a wikipedia page by using the "WIKIPEDIA:" link namespace: "Here is a link to the wikipedia article about [[WIKIPEDIA:Norway|Norway]].
See more formatting tips in WikiFormatting.

or cancel

Reply to comment #8

Comment visibility (whether to hide this comment for "regular users")

Selected syntax: Mediawiki ▼

'''Khitan wrote:'''
>I download test program and excel file from here and retested.
> 
> Two screen recording are attached.
> Repro1 shows detailed procedure and the result, collecting 3 times.
> Repro2 shows OK button is requesting * almost unconditionally.
> 
> There was my mistake of leaving "Fields to Collect" of Quote Manager as
> default.
> I configured it to collect Trade, Ask, Bid.
> The result was that it collected trade, ask, bid, but trade was collected 3
> times, ask, bid the same.
> Trade price pair (R1C1, R1C2). Bid pair (R1C3, R1C4), Ask pair (R1C5, R1C6)
> in one sheet must have relation to this problem.
> If I put these pairs to different sheets of their own(sheet1, sheet2,
> sheet3 for Trade, Bid, Ask), then each collected 1 time.
> 
> I wonder if these behaviors are by design or bug.
> If it is by design, then documentation should include a statement, "When
> using excel as dde server, do not put pairs in one row, the only choice is
> put them in different sheet of same row, since Rn should be the same for
> Trade, Ask, Bid".
> 
> If OK button do not look for *, then I can name symbol whatever I want, and
> put pairs anywhere in the excel.
> 
> 
>

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

Don't worry about URLs - they will automatically be transformed to links.
See more formatting tips in MarkdownFormatting.

URLs will be automatically transformed to links. If you want to add a title, use the link formatter: [[http://awesome.com/something An awesome link]].
See more formatting tips in WikiFormatting.

or cancel

#9

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 16, 2017 - 03:27

A file was uploaded. Repro1.wmv

#10

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 16, 2017 - 03:27

A file was uploaded. Repro2.wmv

#11

MultiCharts Support (MultiCharts)

MultiCharts Support
Last seen online at Apr 17, 2024 - 12:37
Show user details

Aug 16, 2017 - 15:24

1. This issue is related to your application, that you use for sending data, it is working incorrectly. It might not be visible in Excel, but is incorrect in MC, as they are working with data differently. The easiest test will be to manually type in Excel 1, 2, 3 for each cell and make sure that each value is coming into MC and only once.

2. Once you change any data feed settings, or especially create a new data feed (for example, a new DDE data feed) it is always required to completely restart MultiCharts and all its processes. In case it is done properly, no error messages will appear.

#12

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 16, 20:30, in reply to comment #11

I did manually typed in excel cells, the result still confirms that trade, ask, bid were collected each 3 times. I attached "Manual Typing.wmv" which recorded my manual typing and the result. I launched 3 charts each displaying Trade, Bid, Ask. After typing, I shutdown MC and relaunch QuoteManger.

I think this is a bug. we can see that there are 3 change nofication cells, all price cells. Change of Trade price cell caused Ask and Bid collected. Then it must be a bug, or by design(?)

Reply to comment #12

Comment visibility (whether to hide this comment for "regular users")

Selected syntax: Mediawiki ▼

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples between two "~~~~" lines.
See more formatting tips in MarkdownFormatting.

To specify bold text put text between two stars, and for underlines put text between two underscores.
See more formatting tips in MarkdownFormatting.

To auto-link to an existing issue, write "issue", "bug", "ticket" or the issue type (like "bug report" or "enhancement") followed by the issue number (ex: "ticket #3" or "bug report MYPROJ-1"). Enclose sourcecode samples in tags.
See more formatting tips in WikiFormatting.

or cancel

#13

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 16, 2017 - 20:31

A file was uploaded. Manual Typing.wmv

#14

Khitan (chi jeongki)

chi jeongki
Last seen online at Apr 02, 2020 - 01:11
Show user details

Aug 16, 21:17, in reply to comment #11

Anyway, I can create DDE symbol collecting Trade, Ask, Bid by spliting these into seperate sheets, as I mentioned. Symbol names R1, R2, .... are not so good, but I can use them, if OK button insists on using * in item name. So, let's close this problem.

#15

MultiCharts Support (MultiCharts)

MultiCharts Support
Last seen online at Apr 17, 2024 - 12:37
Show user details

Aug 17, 2017 - 11:34

We will test it once again and let you know.