nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Strike

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.

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

Find more posts tagged with

Investments

Windows

File Import

Accepted answers

Jim_Harman

@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.

All comments

Tom Young

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

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.

Strike

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

@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

Jim_Harman

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

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

Strike

@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.