tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/7480-how-does-md-determine-new-investment-transactions-when-downloadingInfinite Kind: Discussion 2023-05-03T03:30:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/577615222023-01-31T01:43:21Z2023-02-01T12:22:44ZHow does MD determine "new" investment transactions when downloading?<div><p>You are talking about Schwab which means you are using Moneydance+ and hence Plaid.</p>
<p>Plaid use its own API so you would have to look on the Plaid site for documentation. I envisage the documentation would answer most of your questions, I do not know if any of the users here have looked at is as they have QIF and OFX.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/577615222023-02-01T01:50:58Z2023-02-01T12:22:44ZHow does MD determine "new" investment transactions when downloading?<div><p>Hi dwg. I had initially thought as much... but when I went to their API website and look at sample responses (e.g. <a href="https://plaid.com/docs/transactions/transactions-data/#pending-and-posted-transactions">https://plaid.com/docs/transactions/transactions-data/#pending-and-...</a>) there's a difference in how Plaid v. MD shows data (if I'm looking at the right stuff).</p>
<p>For example: via the Plaid API the data is in a easily human-readable "name: value" format, e.g.</p>
<p>"transaction_id": "lPNjeW1nR6CDn5okmGQ6hEpMo4lLNoSrzqDje", "pending_transaction_id": "BxBXxLj1m4HMXBm9WZZmCWVbPjX16EHwv99vp", "pending": false, "name": "Apple Store", "amount": 2307.21</p>
<p>When I look at some right-click data in MD I see stuff like this:</p>
<p>0.acctid: 88c1af08-299f-44d5-b349-54755b95e9b1<br>
0.desc: Sonic Drive-In<br>
0.id: fb6eb29a-b9bc-4ee5-b1e8-157fce1483ba<br>
0.obj_type:<br>
0.oldid: -1<br>
0.pamt: -1600<br>
0.samt: 1600<br>
0.tags:<br>
acctid: c0b3a97c-443c-4eed-b09e-b7fde6a9fa80<br>
chk:<br>
desc: Sonic Drive-In<br>
dt: 20230128<br>
dtentered: 1675087478151</p>
<p>Overall this is more an intellectual question (and not a bug), and if anyone has a quick answer great if not I'm not going to lose sleep :-)</p></div>gbonawitztag:infinitekind.tenderapp.com,2009-01-14:Comment/577615222023-02-01T03:16:36Z2023-02-01T12:22:44ZHow does MD determine "new" investment transactions when downloading?<div><p>just a user - the "key" to your question is in a few fields, but I tend to call it fitxnid:</p>
<p>"fi_id" = "mdplus:KzeQ81Xwe0TyZoV9Y6amuONrBPnMXZHQLo6ZL" "fitxnid" = "JzeyYDVdevT3kpDNnykvSdPwkojRKkC0mvvBb"</p>
<p>With OFX it was a bit simpler, as MD+ has a similar (but different) id. I grabbed a "right click" transaction and see basically two sets of these ids with slightly different names.</p>
<p>fitxnid is basically the secret sauce that says - yep, you've downloaded this item, and can skip it when you download it again.</p>
<p>So when you delete one of those two items, MD says "oh, wait, xyzzyplughplover isn't a fitxnid I see - this must be NEW - and boom, you see it downloaded politely for you, even though you intended it to stay gone. The other item you edited isn't redownloaded, because its fitxnid is still there.</p>
<p>How long? Schwab is odd in that it can retain 6-18 months of data depending on the account type. So, it can be a very long time. That said, MD's "last download date" can, but doesn't always, say not to look at anything before a certain date, but I've tended to ignore that.</p>
<p>What I do, is instead of deleting the unnecessary item (yes, I've done things like this) is to just zero it out and let it sit. I eventually delete it, after a bit of time, and then it is just cleanup, and by then it isn't around anymore to be redownloaded (I cleaned up [deleted] about 10 items from 2021 and 2022 as I started doing my taxes - not really necessary, since the value is zero, but I do it anyway)</p>
<p>Hope that helps.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/577615222023-02-01T03:21:21Z2023-04-12T06:20:38ZHow does MD determine "new" investment transactions when downloading?<div><p>I like the 0-ing it out idea and will try that!</p>
<p>Thx</p></div>gbonawitz