1

Integrating with Yahoo! Finance / Downloading your Yahoo! Finance portfolios into Investment Account Manager

« Last post by Forum Administrator on May 07, 2019, 10:35:03 AM »

Importing your portfolio from Yahoo! Finance

Having the ability to manage your portfolio holdings within Investment Account Manager v3.1.6 will provide many important tools and reports not available in Yahoo! Finance. IAM allows:

   Centralized Secure Portfolio Management – Desktop Application – totally private
   Multiple Portfolio Management and Collective Reporting
   Detailed, Informative and Customizable Reporting
   Portfolio Allocation and Rebalancing Analysis
   Mutual Fund Composition Analysis – Asset Type, Sector
   Portfolio Performance with Benchmark Comparisons
   Fundamental Ratio Analysis
   Financial Institution Downloads
   Automatic Security Price Updating
   Mutual Fund Composition Analysis
   Create Historical Pricing Databases

Since 1985 Investment Account Manager has provided investors with detailed portfolio management tools and professional reporting.
 
Importing from Yahoo! Finance

To Import your Yahoo! portfolio, simply follow these steps.

1.) Go to https://finance.yahoo.com/ and then select My Portfolio (see attachment 1).

Select the portfolio you wish to export to IAM to open within Yahoo!

2.) Next click on Export (see attachment 2).

This will create a file called “quotes.csv” which will be saved to your PC's download folder.
 
Creating the portfolio in Investment Account Manager.

3.) Start IAM and selected File Menu | Import | Yahoo Portfolio Data (see attachment 3).

4.) Now give the portfolio a name within Investment Account Manager (see attachment 4), and then click on Next.
 
5.) Select the location of the file downloaded from Yahoo!, then the file, and then the Select button (attachment 5) and then click on import (attachment 6).
                  
6.) Check the following screens closely for any editing which may be needed (attachments 7 and 8 ).
 
7.) Review IAM's import audit report (attachment 9).

Your portfolio is now part of Investment Account Manager, as shown on IAM's Home Page (attachment 10).

Please see www.investmentaccountmanager.com for video tutorials, forums, blogs, and other help, including access to our team.

Thank you for your interest in Investment Account Manager.

2

Integrating with Yahoo! Finance / Uploading your IAM portfolio to Yahoo! Finance

« Last post by Forum Administrator on May 07, 2019, 09:59:57 AM »

Exporting your IAM portfolio to Yahoo! Finance

Having the ability to monitor your portfolio holdings online is easy to accomplish with IAM v3.1.6 and Yahoo Finance.   

Users will need to decide: Do I want my actual share values (lot by lot) uploaded, or simply the security names without actual values.

Both methods provide meaningful results available for review by cell phone, tablet, etc. after installing the Yahoo! Finance free application on your device.

To Import your Investment Account Manager portfolio, simply follow these steps.

1.)   Open IAM and select the portfolio from the portfolios list (see attachment 1).

2.)   Select File Menu | Export | Yahoo Portfolio Data (see attachment 2).
 
3.)   Select your preference: Tax lots (actual portfolio) or One Share of Each Asset (see attachment 3).

4.)    Investment Account Manager will create and save the file to use with Yahoo! Finance.  Note the location of the file so you can find it (attachment 4).

When complete, close the open windows and minimize Investment Account Manager. The next steps deal with setting up Yahoo! Finance.


Steps to complete in Yahoo

1.   Log-into Yahoo (http://www.yahoo.com), or download and install the Smartphone app to your device.

2.   Either sign-in or sign-up for a new account.

3.   After logging into your account, select Finance from the left panel on Yahoo's Home Page, or the Menu Bar. This will take you to Yahoo Finance home page (http://finance.yahoo.com).

4.   Click on “My Portfolio” in the Menu Bar and then Create Portfolio.

5.   Look for “Import”. Click on “Import”.

6.   In the Import window click on “Choose File”. Find the file:(attachment 4 again).
      
then double-click on it to select it for import to Yahoo!, and Submit button. After the page refreshes, you will have uploaded your portfolio to Yahoo!

7.   The final step is to rename your portfolio on Yahoo!’s website: Click on “Settings” then Rename.

That's it... you now can monitor your portfolio from anywhere in the world!

3

User Tips / Using the QuoteMedia Data Feed with IAM3 Individual

« Last post by Forum Administrator on April 16, 2019, 12:36:04 PM »

The QuoteMedia data feed when used with Investment Account Manager 3 Individual provides for much quicker daily market pricing, automatic fundamental analysis, and mutual fund/exchange traded fund compositional data. The QuoteMedia™ data feed is particularly helpful at month end, so with just a few simple clicks, your investments reflect updated fundamental and descriptive data.

QuoteMedia™ offers users the ability to automatically populate and update the fundamental and descriptive data for common stocks. This data, when incorporated into Investment Account Manager, provides the information for powerful fundamental ratio analysis, screening, and asset allocation analysis. Fundamental ratio analysis offers a "snap shot" of a company's value, where the analysis is a review of a firm's financial report.

The QuoteMedia data feed also provides the ability to automatically populate the fund allocation analysis (breakdown by allocation percentages for asset type, sector and size compositions) for mutual funds and exchange traded funds.  These allocation percentages are used in allocation reports to include the portfolio compositions of any funds (mutual funds and exchange traded funds) held in your portfolio when IAM3 Individual derives asset allocation percentages. This means each fund's proportional impact (amount invested in cash, bonds and stocks, by sector, by size) will be included along with any individual holdings of each asset type held outside of your funds, providing a total allocation analysis of your portfolio.

4

User Tips / Collective Reporting - Unified Account Management

« Last post by Peter Willms on April 09, 2019, 10:51:37 AM »

Collective Reporting

In order for a portfolio management tool to be effective, it is essential to thoroughly provide a collective understanding of how your portfolios are integrated, and how the overlap.  This information will allow you to analyze important questions:

   Collectively, am I over/under allocated?
   Am I diversified?
   Do I hold concentrated positions?
   Are the securities I own held in the right accounts – i.e., in deferred vs. taxable?

Investment Account Manager allows users to track an unlimited number of portfolios, each in its own unique database file - transactions are segregated by account.  This provides the user the ability to design portfolios by objective, and to track by individual investment account. 

From collective perspective, IAM allows the combination of portfolios on the program’s many reports.  This powerful ability keeps the user focused on how multiple investment accounts interrelate.

If for example, you are interested in an overall view of value, gains, projected income -the select IAM's Appraisal Report and select the portfolios to combine on the report. Or, if  you are interested in deeper understanding of the overall asset allocation of all of your holdings, you would select Investment Account Manager’s Asset Allocation Report and include all of your portfolios on that report using the report setup screen.  Within seconds, Investment Account Manager will produce a report showing your combined portfolios’ allocation by asset class (cash, bonds, stocks and other), by stock industry sector, and by stock size (large, medium or small cap).

Within Investment Account Manager:
1)   Select the report that is of interest to you from IAM’s Reports Menu. For instance, the Appraisal to see overall value, to review asset allocation, select that choice.

2)   On the Report Setup Window, select which portfolios you wish to include on the report. If you notice a Blue Hyperlink, click on it to provide information (i.e., allocation objectives for the combination – by asset type, size and or sector).

3)   Then, generate the report.

5

User Tips / Using IAM's Batch Reporting Feature

« Last post by Peter Willms on April 09, 2019, 09:57:38 AM »

Batch Reporting

The Batch Reporting feature allows users to produce a series of reports for a selected list of portfolios. For instance, users can customize batch reporting by using the various Report Setup Options to print a series of reports at the end of each month, each quarter or year.
 
Select Reports Menu, then Batch Reports.

Users can define which portfolios to include, and which reports, for specific time periods.
Report Period: depending on the selected report, users can select the reporting period for the batch reporting process.  This includes All Dates, Predefined Date Ranges, Custom Date Ranges, or As of Date. 

   Start Date: starting date range for selected report period.
   End Date: ending date range for selected reporting period.

This feature can be a true time saver when a user has multiple portfolios (accounts), and is producing the same printed report for each.

6

User Tips / Transfer Security

« Last post by Forum Administrator on March 19, 2019, 08:21:44 AM »

The Transfer a Security to Another Portfolio choice is used to transfer either a portion of a security holding or an entire position to another portfolio being tracked in Investment Account Manager.  It can also be used to deliver holdings out of Investment Account Manager (i.e. to a charity).  This feature provides the ability to assign the original cost basis to the transferred security, or to enter a market price of your choice to use for the adjusted (stepped up) basis for the transferred shares.  The basis rules are dictated by the I.R.S.
 
From the Edit Menu, select Transfer a Security to Another Portfolio.  Shown in the Transfer a Security form are all securities currently owned in the open portfolio, listing the total quantity and the current market value.  Select the security you wish to transfer out of the 'donor' portfolio.  Then, in the lower portion of this form, select the 'destination' portfolio for receipt of the transferred shares.  If you are transferring the security to a portfolio not being tracked within Investment Account Manager, (i.e. to a charity, or other outside account), select the check box 'Transfer out of Investment Account Manager'.

Once the transferred security and the destination portfolio (or the choice Out Of Investment Account Manager) have been selected, you can complete the necessary information for the transfer activity.  Investment Account Manager's transfer feature allows you to assign what values to use for the cost basis of shares transferred.  Select the proper radial button to assign original cost basis and basis date for transferred shares, or to assign current market values as cost basis and transfer date for basis information (for inherited shares, gifts to charity, required distributions from non-taxable accounts).  In most cases, the IRS requires the original cost basis and basis date be used for shares transferred. Check with a tax advisor or appropriate IRS publications as necessary.

7

User Tips / Watch Lists

« Last post by Forum Administrator on March 08, 2019, 11:20:43 AM »

User Tip: Watch lists to Improve Decision Making with Investment Account Manager 3 Individual
 
Using 'watch lists' help investors better manage their portfolios by providing alternative investment ideas to use when building or modifying existing portfolios.  A 'watch list' is a grouping of securities in a portfolio that have something in common.  For instance, you might have a watch list for your IRA portfolio, another for your taxable portfolio.  Watch lists can also be effectively grouped by types of securities: i.e., by sector such as Energy stocks, by factor such as Growth stocks, etc.  Investment Account Manager allows for an unlimited number of watch list portfolios that you can maintain with alternative investment ideas.
 
Creating a watch list portfolio in IAM is easy.  Select the Tool Bar | Portfolio Setup Wizard | enter a name | and use the radio button to  'Use quick setup form to manually enter positions'.  Typically, the current date, a quantity of '1' and the current share price is used for populating your watch list.  This will allow you to easily track the performance of the security since its inclusion to the watch list.  Once you've finished the quick setup, you'll have your newly created 'watch list' portfolio available for tracking within IAM3 Individual!

Watch lists also offer very effective “what-if” testing.  For example, users can gauge diversification and allocation impact of additions to an existing portfolio before actually purchasing new securities. This can be easily accomplished by combining a  'watch list' with any existing portfolio(s) on any of the IAM3 reports (using the “Portfolio to include” option on the report setup form).

We encourage you to experiment with watch lists to improve your portfolio management process.  If you have any additional questions on using watch lists in IAM3 Individual, please contact our technical support team: techsupport@investmentaccountmanager.com

8

User Tips / Price Alerts

« Last post by Forum Administrator on March 08, 2019, 11:10:27 AM »

User Tip: Using Price Alerts in IAMv3

The Price Alert feature found in Investment Account Manager (Asset Library Menu | Price Alerts) will allow you to enter target prices for the securities you currently own or are tracking within a watch list.  As part of the automatic price updating feature, you'll be automatically notified once a target price has been reached for one or more issues. Those securities that have exceeded their high alert limit will be shown in green; those securities that have fallen below their low alert limit will be shown in red.  Simply click on the tab labeled 'Security Search' to locate the portfolio(s) that hold the selected issue with the price alert.

The strategy behind your price alerts depends on your objective. You can use Investment Account Manager's price alerts to set your potential high price and potential low price ranges for your securities, in effect setting up your price zone. In this case, you might consider selling a security if the market price reaches the high target, and buying a security if the market price reaches the low target. 

Another strategy might be to set all price alerts at a given percentage value above or below the current market prices. This approach works well if you would like to see which of your securities reach their targets before others, while also helping you manage gains and losses. For example, users can quickly set all price alerts using a range- i.e., 5% above and 10% below each security's current market price.

The price alerts feature in IAM3 Individual is a useful tool to better help you better manage your current holdings, as well as your watch-list candidates.  We encourage you to use this feature, and if you have any questions, please contact our technical support team: techsupport@investmentaccountmanager.com

9

Announcements / IAMv3 Update: 3.1.5 Now Available

« Last post by Forum Administrator on March 01, 2019, 04:14:19 PM »

Investment Account Manager v3 Individual - Maintenance Releases 3.1.5 Now Available

Use the choice 'Check For Updates' located on the IAMv3 Individual Version Menu Bar to automatically verify you are currently running the latest version of Investment Account Manager v3 Individual. You will be notified as to whether or not you have the current version. If not, you will be prompted to download the latest file.

Note: if this choice is inactive in your copy of Investment Account Manager, this indicates your support period has expired. To extend technical support for an additional year, renew thru our website Products page: www.investmentaccountmanager.com.

If you have any questions, contact our technical support team: techsupport@investmentaccountmanager.com

Click here for a listing of improvements/changes/corrections included in IAMv3.1.5:
https://www.investmentaccountmanager.com/maintenance-release.php

10

Frequently Asked Questions / Re: How do I add a money market fund (settlement fund) after a portfolio is made?

« Last post by Peter Willms on February 25, 2019, 10:30:14 AM »

When adding a money market balance to a portfolio that has already been added to IAM, select the Transactions Menu | Add, edit, delete transactions.  This will show the transactions ledger.

Enter the information for the initial deposit (use a reconciled amount that ties back to your portfolio balances).

Be certain that you have classified the mmf as a cash/mmf asset type  - this can be checked in the Asset Library | Current Asset Library.

to use the mmf as the offset for other portfolio activity, be sure that is is selected (checked) at the bottom of the transactions ledger.