Re: N/A massages

[ Q4-Q1 00 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: N/A massages posted by Vladimir on February 10, 2000 at 02:53:19:

: Hi,
: Does anybody know how to solve the problem with N/A massages in "Capital Gains - FIFO" report?
: As I understand it this is happening when you have sold more stocks than you have. But it happens sometimes. Shall I fool myself inputting wrong dates or there is more suitable solution?
: Thanks and best regards,
: Vladimir Agapov
: Moscow, Russia.

Hello Vladimir,
We recently added a new topic in the online help describing this situation,
and how to deal with it, here it is:

The most common cause for a gain being reported as "N/A" in the capital gains reports is that you have sold more shares than you previously purchased. This results in a negative share balance following that redemption. This can be caused by even a very small number of extra sold shares. To determine if this is the case, adjust the significant share digits to display to the maximum (6) using the Options/Preferences.../Display dialog. Then, use the Edit/All Data... dialog to view your daily share balance with the "Prices" data type selected. If you find a small negative share balance, switch the data type to "Investments (all)" and fix the appropriate transaction such that your share balance does not dip negative.

The above method will show negative share balances for the close of each date where a price is recorded. It is also possible that the share balance dips negative, and then returns to positive, within a single day. This could occur if you have a sell recorded, and then another buy recorded for the same date. In this scenario the above method would not as obviously show the problem. When multiple buy/sell transactions are recorded on the same date, make sure they are recorded in chronological order, with respect to the time of day they occurred. When viewing your transactions under the "Investments (all)" you can sort your transactions by "Date", which is the default. If you bought and then sold some shares on the same day, make sure the buy is recorded earlier than the sell. You can accomplish this by recording the buy before your record the sell. If you have your transactions out of order, you can switch them by editing the transaction that occurred last. By simply editing that transaction it will be moved to the last transaction of the day, since multiple transactions within a day are ordered by the time when you last updated them. When editing a transaction to move it, it is not necessary to change any information, just highlight the transaction in the list view, click the "Edit" button, and then dismiss the transaction dialog by pressing the "OK" button.

Thanks,
Mark
--
Mark Beiley

Fund Manager for Windows 3.1x/95/98/NT

Replies: