1
●0 ●1 ●1
Is there a way to pull realtime positions from REDI into Excel?
Hello @ddavenport70 ,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
32.2k
●40 ●11 ●20
Hello @ddavenport70 ,
Review Position Monitor example found in REDI.VB.ExcelExamples on GitHub, is this the what you are looking for?
1
●0 ●1 ●1
thank you, that is a great start, but it seems to limit the amount of accounts I can pull back for. I have 40+ accounts that I need to monitor. Also, can I see the aggregate Positions across all accounts?
32.2k
●40 ●11 ●20
Hello @ddavenport70 ,
This example is part of REDI starter example deck, and is intended as a starter, so it will not fulfill all the requirements for most of the client use cases, you may need to build up to your requirements with any of the starter examples.
In this specific case, the additional requirements are not in terms of creating additional functionality in code, rather, the safeguards you see in place are there for performance reasons, and these are the parameters that the starter example was tested with.
40+ accounts is a significant increase. You can test increasing the max number of allowed accounts via MaxAcctSize, and if number of positions is not sufficient per use case, then also number of positions via MaxPosSize from Initialize(). As you do so, you would need to verify for any performance issues per Excel manifesting during your testing, especially at high market, in my view.
Hope this information helps.
