DDE export: excel data format (, versus .)

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • 11/24/2020 at 10:48 AM #151384 quote
    Canopy78
    Participant
    New

    Hello guys,

    I have an urgent problem to solve in exporting prorealtime data with DDE link to excel.

    In the excel spreadsheet, data format returns alternatively prices as “33395” or “33,395” depending on the stock.

    As I work with a US/UK data formats, coma “,” can’t be used a decimal separator insteed of “.” point. I can”t find where to modify this as you can’t change” 33,365″ by “33.365”. It’s not, possible with the Excel cell format options. Finally it returns an error in my formulas

    Thanks guys for your help.

     

    Cheers,

     

    Gerard

    Excel-DDE-errors-in-formula.png Excel-DDE-errors-in-formula.png
    11/24/2020 at 10:51 AM #151386 quote
    Nicolas
    Keymaster
    Master

    Sorry but are you asking Excel support in the ProRealTime platform support forum? 🙄

    I will move your topic in the general trading discussions.

    I’m sure there is an option to change the number format value, but it is not located in the cell formatting option, it is in the general option of Excel.

    11/24/2020 at 11:04 AM #151392 quote
    Canopy78
    Participant
    New

    Hi Nicolas,

    I am here for prorealtime matter which returns DDE data formats in a “strange way” [alternatively at each tick as “33395” then “33,395”] as mentionned in my post. It’s not first an excel issue.

    Thanks for help.

    12/05/2020 at 4:19 PM #152681 quote
    PeterSt
    Participant
    Master

    Gerard, look here : https://www.officetooltips.com/excel_2016/tips/change_the_decimal_point_to_a_comma_or_vice_versa.html

    I don’t think your problem stops at the thousand-separator, because you’d also be dealing with the decimal separator (depending on the instrument you have in your list).

    My personal opinion : Indeed it should be settable in PRT because for various reasons we can not change the decimal / thousand separator at the higher level in Excel; then other imports etc. won’t work any more.


    @PRT     : It would be a convenience matter just the same, because if you in France read larger numbers like 10.200,55 then you like to use software which presents it like that. People in the UK and USA like to read (or type) this as 10,200.55.

    Peter

    12/06/2020 at 3:50 PM #152743 quote
    Roger
    Participant
    Veteran

    Look at the attached file in this thread :

    https://forum.excel-pratique.com/excel/separateur-de-millier-t12537.html

    12/07/2020 at 9:59 AM #152814 quote
    Nicolas
    Keymaster
    Master

    FYI, we do not use thousands separator in France.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.

DDE export: excel data format (, versus .)


General Trading: Market Analysis & Manual Trading

New Reply
Author
author-avatar
Canopy78 @canopy78 Participant
Summary

This topic contains 5 replies,
has 4 voices, and was last updated by Nicolas
5 years, 3 months ago.

Topic Details
Forum: General Trading: Market Analysis & Manual Trading
Language: English
Started: 11/24/2020
Status: Active
Attachments: 1 files
Logo Logo
Loading...
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)
©2026 ProRealCode - Trading & Coding with ProRealTime™