Tim, Since I still have a working copy of Quicken 2017, I started a new file and then did a single stock split and this is what it looks like when exported from Quicken in QIF format:
!Type:Invst D8/24'22 NBuy YTesla Inc I891.29 Q1 U891.29 T891.29 ^ D8/25'22 NStkSplit YTesla Inc I302.36 Q30 ^ This transaction is for Tesla's 3:1 stock split that happened on Aug 25th. Essentially I bought a single stock of Tesla on Aug 24th at the closing price of $891.29. Then stock split 3:1 on Aug 25th with optional opening price of $302.36. Note that Quantity is listed as thirty - 10x value - on the split date! For kick-&-giggles I set the split to 1000:1 (this split size is limited by Quicken) and this is what it looks like: !Type:Invst D8/24'22 NBuy YTesla Inc I891.29 Q1 U891.29 T891.29 ^ D8/25'22 NStkSplit YTesla Inc I302.36 Q10,000 ^ So from the looks of it, the stock split needs an extra zero on the quantity of after the split quantity. And for split of 1000:3 as follows: !Type:Invst D8/24'22 NBuy YTesla Inc I891.29 Q1 U891.29 T891.29 ^ D8/25'22 NStkSplit YTesla Inc I302.36 Q3,333.333333 ^ So Quicken 2017 on Windows is consistent that the final quantity it stores is 10X of what should be the normal stock split ratio that would be arrived at using strait math. When I imported the first and the last stock split QIF configuration above, GNC v4.11 on Windows imported the QIF (IMHO) as intended. ------------------------------ Message: 2 Date: Thu, 5 Jan 2023 13:51:28 -0600 From: m...@tgr66.me To: gnucash-user@gnucash.org Subject: [GNC] QIF format for StkSplit Message-ID: <7a1892d0-5538-4140-8fd7-e18904494...@tgr66.me> Content-Type: text/plain; charset=utf-8 I?ve searched considerably, but if I missed it, I apologize. Docs for QIF say the Q field should contain the split ratio. I?ve tried various options, but I?m not getting the expected results after import. !Type:Invst D8/31/2020 NStkSplit PAPPLE INC YAAPL CR M4 for 1 split; Q36 // Have also tried 4:1, 4/1 and simply 48 ^ GnuCash 4.13 on macOS. I?ve not tried yet on my Linux box. Thanks. ------------------------------ Message: 3 Date: Thu, 5 Jan 2023 15:02:24 -0500 From: David Reiser <dbrei...@icloud.com> To: m...@tgr66.me Cc: gnucash-user@gnucash.org Subject: Re: [GNC] QIF format for StkSplit Message-ID: <fbea3500-eedf-40f9-8fab-7a3c3a90a...@icloud.com> Content-Type: text/plain; charset=utf-8 I?ve never used QIF for stock splits, but the obvious question is ?Have you tried Q4?? After all, 4/1 is numerically equal to 4 (a ratio reduced to a single number). -- Dave Reiser dbrei...@icloud.com > On Jan 5, 2023, at 2:51 PM, m...@tgr66.me wrote: > > I?ve searched considerably, but if I missed it, I apologize. > > Docs for QIF say the Q field should contain the split ratio. I?ve tried various options, but I?m not getting the expected results after import. > > !Type:Invst > D8/31/2020 > NStkSplit > PAPPLE INC > YAAPL > CR > M4 for 1 split; > Q36 // Have also tried 4:1, 4/1 and simply 48 > ^ > > GnuCash 4.13 on macOS. I?ve not tried yet on my Linux box. > > Thanks. > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ------------------------------ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
