Downloading data to external files. Is possible?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #235579 quote
    MCG
    Participant
    New
    Is there a possibility to download the prices of a share to an external file?
    #235580 quote
    PeterSt
    Participant
    Master

    In the Main Menu under Setup there’s the option “DDE Stream On”. With this you can export the instruments visible in current Lists on the screen to Excel. This is a live stream. You can filter out instruments you don’t want to see showing up in Excel.
    If you add a List especially for this, you can let show up in Excel what you want. You can *not* appoint existing Lists to not show up in Excel. In this regard the Portfolio is a List too and that is dynamic (contains your Positions and they change). I deem this a negative, but alas.

    Regards,
    Peter

    Iván González and MCG thanked this post
    image_2024-07-21_071420463.png image_2024-07-21_071420463.png
    #235610 quote
    MCG
    Participant
    New

    I already knew this possibility, but I was asking about the possibility of exporting ENTIRE series to subject them to a more complete statistical and mathematical analysis. In fact, I’m already doing this with R, possibly the best (and free!) statistical software. In any case, thank you very much for your response.

    Manuel.

    #235619 quote
    Iván González
    Moderator
    Master

    Hello. If what you are looking for is to obtain historical quote data, this is not possible.

    #235620 quote
    MCG
    Participant
    New

    I know, Ivan. And it's a shame, because I think the PRT data is of high quality. Read my previous post. The problem with R is that from time to time the sources (Yahoo, Google, etc.) stop supplying data. And then everything goes to hell. Anyway, thank you very much. Manuel

    #235639 quote
    alfredocuaresma
    Participant
    New

    you can do it. It is not trivial, but technically it is possible and it does not take long either. You create a bot with 1M dollars in the account (simulated in backtesting), you set it to buy as many positions in each candle as the share price is worth, and in the next one to close, sell everything. And this will be the case in each backtesting candle. You do the backtesting, you go to the closed positions indicator, and that will precisely serve as a history of the price of your action in all the candles that you have run it.

    MCG thanked this post
    #235645 quote
    robertogozzi
    Moderator
    Master

    Hey guys, please only post in the language of the forum that you are posting in. For example English only in the English speaking forums and French only in the French speaking forums.

    Thanks 🙂

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

Downloading data to external files. Is possible?


Platform Support: Charts, Data & Broker Setup

New Reply
Author
author-avatar
MCG @mcg Participant
Summary

This topic contains 6 replies,
has 5 voices, and was last updated by robertogozzi
1 year, 6 months ago.

Topic Details
Forum: Platform Support: Charts, Data & Broker Setup
Language: English
Started: 07/20/2024
Status: Active
Attachments: 1 files
Logo Logo
Loading...