tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5699-currency-allocationInfinite Kind: Discussion 2021-05-17T23:00:26Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/490187822021-02-06T11:14:44Z2021-02-06T11:14:44ZCurrency allocation<div><p>That's an interesting one.... The closest std report is account balances, but that just lists by account and then converts the amount to base currency for the total.. I guess you could export that and fiddle with it..</p>
<p>I have a number of extracts which would get you closer. You probably would want the extract_account_registers and extract_investment_transactions to csv. You can load into excel, insert a pivot table and do it that way... NOTE: This extracts transactions, but if you extract all you would get to the account balances with the pivot summing the totals...<br>
<a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p>
<p>I don't have an extract account balances version (yet) sorry.</p>
<p>NOTE: Mike Bray has a new extract tool (it's in beta). You can get here:</p>
<p><a href="https://infinitekind.tenderapp.com/discussions/general-questions/108251-new-reporting-extension">https://infinitekind.tenderapp.com/discussions/general-questions/10...</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490187822021-02-06T11:42:28Z2021-02-06T11:42:28ZCurrency allocation<div><p>An update... I just tested with Mike's extension and you can get the balances dumped to excel and then pivot on currency etc.... so another route...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490187822021-02-08T12:06:36Z2021-02-08T12:06:37ZCurrency allocation<div><p>Thank you so much! will deep dive into this.<br>
I really appreciate it</p></div>Dmitriitag:infinitekind.tenderapp.com,2009-01-14:Comment/490187822021-02-15T22:55:22Z2021-02-15T22:55:22ZCurrency allocation<div><p>FYI - All my extract scripts have now been consolidated into a single script/extension called extract_data. The old individual scripts have been decommissioned.</p>
<p><a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p></div>Stuart Beesley (Mr Toolbox)