[GNC] QIF format for StkSplit

[Kalpesh Patel]

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: ml at tgr66.me
To: gnucash-user at gnucash.org
Subject: [GNC] QIF format for StkSplit
Message-ID: <7A1892D0-5538-4140-8FD7-E1890449408F at 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 <dbreiser at icloud.com>
To: ml at tgr66.me
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] QIF format for StkSplit
Message-ID: <FBEA3500-EEDF-40F9-8FAB-7A3C3A90A3E0 at 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
dbreiser at icloud.com





> On Jan 5, 2023, at 2:51 PM, ml at 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 at 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.



------------------------------