Filtering with Basic Find Commands

Published: June 9, 2014
Tagged: TradeLog Tips

TradeLog offers a range of useful filters for trade analysis. In part 1 of this series, I explained how to effectively use the Find>Ticker function. In this second part, you will learn about simple Find functions that will help you quickly isolate certain types of securities or certain types of records.

TradeLog Find menu

Each of these Find functions can be found by opening your TradeLog file and clicking on the Find menu. The functions selections and commands explained in this article are:

... as well as:

How are the Find commands useful?

Finding Certain Security Types

Commands for finding by security type.

The basic Find commands are the quickest way to display all trades of a particular security type for trade analysis purposes. For example, if you needed to see only your stock trades in your TradeLog file without showing any other financial instruments, you can click on the Find menu and then select the menu item Stocks.

Or say you would like to run a simple P&L report on all your mutual funds just for the month of June. The easiest way to do this is to click on the Find menu, then select Mutual Funds. As a result, TradeLog will display only your mutual fund trades. Now, click on the Reports menu and choose the Realized P&L. Then set the report date range you want and click on the Run Rpt button.

The same can be applied to isolating your Options trades, ETFs/ETNs, Dividend Reinvestments (Drips), Futures and Currencies by selecting the appropriate choice from the Find.

Finding Matched Tax Lots

Perhaps you are more interested in viewing all the trades in TradeLog that were matched by using the Edit>Match Tax Lots function. Simply click on the Find menu and select Matched Tax Lots. TradeLog will only display those records that were matched. Each matched trade has a number in the "Matched" column. (If you cannot see that column, click on the View menu and then select Display Matched.)

Finding Exercises / Assigns

Did you earlier run the Exercise/Assign function to adjust your exercised options? You can now view all those trades that were involved in the exercise/ assignment process. Click on the Find menu and then select Exercises/ Assigns, TradeLog will give you a list not only of all the options that were exercised, but also the related stock trades that were adjusted by the option premium.

Finding Duplicate Trades

This may be a function you rarely need. Usually, if you took care to import only once, to not manually enter the same trade multiple times, to not add missing records unless you are absolutely certain they are missing and if your broker did not make a mistake on the broker trade history data that was imported, then you should not have a need to use this function. However, if you are suspicious that any of the above situations could have impacted your TradeLog file, then click on the Find menu, select Duplicate Trades and enter the ticker you want to investigate for duplications.

Finding Invalid Option Tickers

If TradeLog finds that an option ticker symbol is not in the correct format, it will alert you in form of an error message when you first open the TradeLog file. If you hit your ESC (Escape) key on your keyboard or click on Close to close the error message, you have several ways to view list of all the options with the erroneous ticker symbol. You can click on the ALL Trades button, or hit your ESC key again, or click on the Find menu and click Invalid Option Tickers.

Two additional selections from the Find menu were not discussed in this article - "Grid Filter Dialog" and "Lookup Ticker". These will be explored in a future blog article. Of course, in the meantime, you can learn more about all of the available filters in the TradeLog User Guide.

Please note: This information is provided only as a general guide and is not to be taken as official IRS instructions. Cogenta Computing, Inc. does not make investment recommendations nor provide financial, tax or legal advice. You are solely responsible for your investment and tax reporting decisions. Please consult your tax advisor or accountant to discuss your specific situation.