すべての注文
ルール
指定
Hello Developers,
I need some consultation to help narrow down an idea and develop an EA. I have a csv file that stores data like this:
| Date | portfolio | portfolio_value |
| 18/11/2025 | ['EURNZD', 'EURCAD', 'EURJPY', 'EURCHF', 'AUDNZD', 'AUDCAD', 'AUDJPY', 'AUDCHF', 'USDNZD', 'USDCAD', 'USDJPY', 'USDCHF', 'GBPNZD', 'GBPCAD', 'GBPJPY', 'GBPCHF'] | 1.7970698812202368 |
| 19/11/2025 | ['CHFAUD', 'CHFNZD', 'CHFGBP', 'CHFJPY', 'EURAUD', 'EURNZD', 'EURGBP', 'EURJPY', 'USDAUD', 'USDNZD', 'USDGBP', 'USDJPY', 'CADAUD', 'CADNZD', 'CADGBP', 'CADJPY'] | 2.3329507054813736 |
| 20/11/2025 | ['JPYAUD', 'JPYNZD', 'JPYGBP', 'JPYCHF', 'EURAUD', 'EURNZD', 'EURGBP', 'EURCHF', 'USDAUD', 'USDNZD', 'USDGBP', 'USDCHF', 'CADAUD', 'CADNZD', 'CADGBP', 'CADCHF'] | 5.803608144876992 |
| 21/11/2025 | ['JPYAUD', 'JPYNZD', 'JPYGBP', 'JPYCHF', 'EURAUD', 'EURNZD', 'EURGBP', 'EURCHF', 'USDAUD', 'USDNZD', 'USDGBP', 'USDCHF', 'CADAUD', 'CADNZD', 'CADGBP', 'CADCHF'] | 6.813640731557092 |
| 24/11/2025 | ['EURAUD', 'EURNZD', 'EURCAD', 'EURJPY', 'USDAUD', 'USDNZD', 'USDCAD', 'USDJPY', 'CHFAUD', 'CHFNZD', 'CHFCAD', 'CHFJPY', 'GBPAUD', 'GBPNZD', 'GBPCAD', 'GBPJPY'] | 3.6412664761397373 |
| 25/11/2025 | ['EURAUD', 'EURNZD', 'EURCAD', 'EURJPY', 'USDAUD', 'USDNZD', 'USDCAD', 'USDJPY', 'CHFAUD', 'CHFNZD', 'CHFCAD', 'CHFJPY', 'GBPAUD', 'GBPNZD', 'GBPCAD', 'GBPJPY'] | 5.153264738552588 |
| 26/11/2025 | ['EURAUD', 'EURNZD', 'EURCAD', 'EURJPY', 'USDAUD', 'USDNZD', 'USDCAD', 'USDJPY', 'CHFAUD', 'CHFNZD', 'CHFCAD', 'CHFJPY', 'GBPAUD', 'GBPNZD', 'GBPCAD', 'GBPJPY'] | 5.626267359851079 |
| 27/11/2025 | ['EURAUD', 'EURNZD', 'EURCAD', 'EURJPY', 'USDAUD', 'USDNZD', 'USDCAD', 'USDJPY', 'CHFAUD', 'CHFNZD', 'CHFCAD', 'CHFJPY', 'GBPAUD', 'GBPNZD', 'GBPCAD', 'GBPJPY'] | 0.9480722215423953 |
| 28/11/2025 | ['NZDAUD', 'NZDCAD', 'NZDGBP', 'NZDJPY', 'EURAUD', 'EURCAD', 'EURGBP', 'EURJPY', 'USDAUD', 'USDCAD', 'USDGBP', 'USDJPY', 'CHFAUD', 'CHFCAD', 'CHFGBP', 'CHFJPY'] | 0.017755719 |
| 01/12/2025 | ['NZDAUD', 'NZDCAD', 'NZDGBP', 'NZDJPY', 'EURAUD', 'EURCAD', 'EURGBP', 'EURJPY', 'USDAUD', 'USDCAD', 'USDGBP', 'USDJPY', 'CHFAUD', 'CHFCAD', 'CHFGBP', 'CHFJPY'] | -2.15614944 |
| 02/12/2025 | ['NZDAUD', 'NZDCAD', 'NZDGBP', 'NZDJPY', 'EURAUD', 'EURCAD', 'EURGBP', 'EURJPY', 'USDAUD', 'USDCAD', 'USDGBP', 'USDJPY', 'CHFAUD', 'CHFCAD', 'CHFGBP', 'CHFJPY'] | -1.976555216 |
| 03/12/2025 | ['NZDAUD', 'NZDCAD', 'NZDGBP', 'NZDJPY', 'EURAUD', 'EURCAD', 'EURGBP', 'EURJPY', 'USDAUD', 'USDCAD', 'USDGBP', 'USDJPY', 'CHFAUD', 'CHFCAD', 'CHFGBP', 'CHFJPY'] | -1.775490478 |
| 04/12/2025 | ['NZDAUD', 'NZDCAD', 'NZDGBP', 'NZDJPY', 'EURAUD', 'EURCAD', 'EURGBP', 'EURJPY', 'USDAUD', 'USDCAD', 'USDGBP', 'USDJPY', 'CHFAUD', 'CHFCAD', 'CHFGBP', 'CHFJPY'] | -4.630087808 |
The date column is in UTC format.
portfolio is the column that contains a list of currency pairs that I want to look in to.
portfolio_value is the value of a particular portfolio at a specific date.
I want the EA buy the portfolio if the date in my csv file is one day earlier than the broker time (in UTC), and portfolio_value is less than -0.25 (input).
I want the EA sell the portfolio if the date in my csv file is one day earlier than the broker time (in UTC) and portfolio_value is greater than 0.25 (input).
Cost per pip is important; all should have the same cost per pip (in USD)
If I am buying the portfolio, I want it to close above -0.25 (input). If I am selling, I want it to close below the 0.25(input).
After position has been opened, the EA will continuously check the csv file over and over again due to continuous updates.
I might open positions for a long time, so due to swaps, the EA needs to open more positions when needed accordingly.
Because there are continuous updates, the EA need to keep up with the changes happening; sometimes it need to close some positions and open new positions.
That's a lot in my mind right now, I am having a hard time framing it.
I will not hire a developer before I receive an EA that I can test over 4 weeks, and I can also backtest in the strategy tester.