Downloading data to external files. Is possible?

• 07/20/2024 at 7:38 PM #235579
  MCG

  <span class="Y2IQFc" lang="en">Is there a possibility to download the prices of a share to an external file?</span>

  1	<span class="Y2IQFc" lang="en">Is there a possibility to download the prices of a share to an external file?</span>

  

  MCG

  Participant

  Topics: 3

  Replies: 6

  Been thanked: 2 times
  07/21/2024 at 6:20 AM #235580
  PeterSt

  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

  2 users thanked author for this post.

  MCG, Iván

  

  PeterSt

  Participant

  Topics: 73

  Replies: 2451

  Been thanked: 774 times
  07/22/2024 at 9:17 AM #235610
  MCG

  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.

  

  MCG

  Participant

  Topics: 3

  Replies: 6

  Been thanked: 2 times
  07/22/2024 at 10:27 AM #235619
  Iván

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

  

  Iván

  Moderator

  Topics: 0

  Replies: 714

  Been thanked: 230 times
  07/22/2024 at 10:38 AM #235620
  MCG

  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

  

  MCG

  Participant

  Topics: 3

  Replies: 6

  Been thanked: 2 times
  07/22/2024 at 5:30 PM #235639
  alfredocuaresma

  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.

  1 user thanked author for this post.

  MCG

  

  alfredocuaresma

  Participant

  Topics: 6

  Replies: 7

  Been thanked: 11 times
  07/22/2024 at 7:47 PM #235645
  robertogozzi

  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 🙂

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16797

  Been thanked: 3830 times
• Author
  Posts