Is there a feature where I can use an API ? (This would be amazing 🙂 )
This would be so very useful for collecting backtest or live data and using MS Power Automate, have the data correctly transferred to the excel sheet (cell locations)?
Or what is the email output format, is that using a CSV file ? – can still use Power Automate, but the set up is longer…
PDF email attachment is ok, but the data extraction can be fiddly, even for Power Automate.
Any feedback is much appreciated (I have pinged this over to support also).
My thanks, as always,
NT
This is a code free post, thanks to a specialist version of CGPT Designed for the PRT Platform 🙂
This would be so very useful for collecting backtest or live data
NT, forget it. 🙁 The output via DDE only outputs data from Lists (with the remark that you can create the Lists yourself). But all that would expose is price data for he instrument(s) in that List (all the Lists on screen). This functionality is nice all right (it connects to Excel), but is not at all what you want.
Other than this, there’s no I/O possible whatsoever.
Very maybe you can use Excel-exports from various quite static functions, like the output of an optimisation run (this is backtest related). But it is all not made for what you want …
We can export to CSV from, for example, Detailed Report etc (see ‘Export icon’ in top RH corner) I have set up Pivot Tables and Charts from the csv in excel.
All worked and gave me what I was after (best Algo today / this week etc) but the csv data is limited to 1,000 lines! It became yet another annoying time-consuming faff to (manually) update the csv files regularly enough (each day, maybe more often at times) to maintain the full ongoing record of transaction to compute full Portfolio performance.
User friendly / practicable ‘Analysis Tools’ would make the PRT Platform much more comprehensive / all-inclusive!?
Even if the platform is limited, MSPA will automate said usage of data, at cell level in your excel sheet, and arrange the data output as you desire…
Happy days 🙂
NT
NeoTrader wrote: <<< Did you see this post !!! If you use AI, this AIM is well worth a look… for real 🙂
Well, if i can get the data in CSV format, and using Power Automate to utilise the data into my awaiting excel sheets, I am in very good hands…
I’ll be testing that this weekend…
Unless you can get MSPA (or some other tool?) to take over your PC and click buttons then your automation idea may fall at the first hurdle because PRT does not provide Export on a auto-schedule function.
I hope somebody tells me I am wrong?
I sincerely hope you get the Automation working NT.
That’s the idea…
It is easy to use…
Spend time watching the videos, taking notes, then jump in, and give it a go…
Let me know how you get on…
Oh, and do click the ‘thanks’ button on the previous post for me 😉
NT
PS. If you use CGPT for coding assistance, I am amazed as this specialist version of the ProRealTime Code CGPT model…
With a good project set up of files and instructions, it is making huge headway coding my backtesting templates.
And it is also suggesting ways of designing indicators to serve as a monitor (5 indicator algo), very impressive…
🙂
Please keep us Posted NT, let us know if you get it all working re data into Excel etc.
I often feel jaded struggling with various parts of PRT. We need ‘new blood’ (e.g. You! 🙂 ) / new ideas to renew our enthusiasm.
I’m hoping for a ‘lift’ with PRT v13 … I hope v13 doesn’t disappoint!?
I am on it my friend…
But, be aware, I do not auto trade…
I mostly use the daily and a 5 indicator algo traffic light system… (Currently in python code).
I did this, as platforms can be limiting… and I prefer as much control as possible 🙂
But, when I find something useful, I’ll share, of course…
This topic contains 12 replies, has 4 voices, and was last updated by NeoTrader 9 months ago.
Topic Details
Forum:
ProOrder: Automated Strategies & Backtesting
Language:
English
Started:
05/15/2025
Status:
Active
Attachments:
No files
Loading...
About personal data collected
The information collected on this form is stored in a computer file by ProRealCode to create and access your ProRealCode profile. This data is kept in a secure database for the duration of the member's membership. They will be kept as long as you use our services and will be automatically deleted after 3 years of inactivity. Your personal data is used to create your private profile on ProRealCode. This data is maintained by SAS ProRealCode, 407 rue Freycinet, 59151 Arleux, France. If you subscribe to our newsletters, your email address is provided to our service provider "MailChimp" located in the United States, with whom we have signed a confidentiality agreement. This company is also compliant with the EU/Swiss Privacy Shield, and the GDPR.
For any request for correction or deletion concerning your data, you can directly contact the ProRealCode team by email at privacy@prorealcode.com
If you would like to lodge a complaint regarding the use of your personal data, you can contact your data protection supervisory authority.
Get Assistance
Assistance Type
Your Need
Proposed Solutions
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website.
(Learn more)