How do I import Investment data without affecting the cash balance [Edited]

Strike
Strike Quicken Windows Subscription Member ✭✭
edited November 11 in Registers & Transactions (Windows)

Hello,

It seems that something changed since the last time I tried importing historical investment data. Based on post

https://community.quicken.com/discussion/7952277/how-do-i-import-investment-data-without-effecting-the-cash-balance

I followed this format:
!Type:Invst
D07/25/2024
NBuyX
YInvestment Name
I42.39954
Q3.8399
$162.81
T162.81
CC
L[AccountName]
MContribution
^

However, the process creates 2 lines now no mater what I do.

image.png

I have tried changing the $ back to U, and changing NBuyX to NBuy and NBuyx and various combination there of. I do not understand why I cannot get the process to place BoughtX in the line instead of doing the cash balancing item. I also tried removing the L line, but then it does not process the file and does not give you any error or warning.

Both the Y and L lines are completed with the correct data, just did not want to put those in the chat.

Any help or ideas would be greatly appreciated as I want to get my wife's historical investment data loaded.

Thank you

Trevor

Tagged:

Best Answer

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 13 Answer ✓

    @Strike The N/A and Balancing Cash Adjustment in the transactions you show above indicate that there are one or more Placeholders in your file for that security with a date later than the transaction you are entering. With a Placeholder in the account, Bought and Sold will not affect the cash balance, but the Placeholder will force the share balance on the Placeholder date to match the balance in the Placeholder.

    If you delete the Placeholder(s), Bought and Sold transactions will affect the cash balance. If you want the transactions to just affect the share balance without affecting the cash balance, Added and Removed are the transactions to use. If the funds for the transactions are transferred to or from another account, it would be BoughtX or SoldX.

    I can provide more background on Placeholders if you want it.

    Always back up your data file before messing with historical data.

    QWin Premier subscription

Answers

  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭

    It's been decades since I even glanced at a QIF file but I thought there was an ADD or SHRIN action you could use? There's no cash associated with such a transaction.

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    The easiest way to figure out what syntax you need for a given QIF transaction is to enter the given transaction like Add Shares into Quicken and then just do an export of that transaction/day in QIF format.

    Signature:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/

  • Strike
    Strike Quicken Windows Subscription Member ✭✭

    Thank you @Chris_QPW for your advice, however that did not work. I took a transaction from that file and loaded it after changing only the date, and I get the same results. It appears that Quicken is not processing the NBuyX or NSellX any differently then it does the NBuy and the NSell other than requiring the L[Account Name] in the load file.

    I have also tried using the ImportQIF program with the CSV I exported from the website, and no matter what I do, it also gives me the 2 lines and only uses Bought and Sold not the BoughtX and SoldX.

    Thank you for your help. I will call the support team.

    Trevor

  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭

    @Strike it sounds like you may be running into the issue described here:

    https://community.quicken.com/discussion/7963599/bought-with-transferred-funds-not-working

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 13 Answer ✓

    @Strike The N/A and Balancing Cash Adjustment in the transactions you show above indicate that there are one or more Placeholders in your file for that security with a date later than the transaction you are entering. With a Placeholder in the account, Bought and Sold will not affect the cash balance, but the Placeholder will force the share balance on the Placeholder date to match the balance in the Placeholder.

    If you delete the Placeholder(s), Bought and Sold transactions will affect the cash balance. If you want the transactions to just affect the share balance without affecting the cash balance, Added and Removed are the transactions to use. If the funds for the transactions are transferred to or from another account, it would be BoughtX or SoldX.

    I can provide more background on Placeholders if you want it.

    Always back up your data file before messing with historical data.

    QWin Premier subscription
  • Strike
    Strike Quicken Windows Subscription Member ✭✭

    @Jim_Harman , thank you for your help. I forgot that I needed to delete the placeholder. You would have thought the support person would have mentioned that. I will try deleting the Placeholder and load it again.

Categories