Archive for the 'Documentation' Category

Investoscope Alternative

Dec. 15th 2016

The developers of Investoscope recently announced that they are no longer developing or supporting their software. Investoscope users may now be wondering what to do and if there is an Investoscope alternative app that they can use to manage their investments.

Replacement for Investoscope

Investoscope was a capable and useful portfolio tracker. However, Investoscope users looking for a replacement will find that StockMarketEye offers many of the same capabilities. StockMarketEye also provids additional features that help the modern investor track and manage their investments.

In addition to providing top-notch portfolio tracking and management features, the following features show just how much StockMarketEye has to offer as an alternative to Investoscope.

Migrating from Investoscope to StockMarketEye

Moving to StockMarketEye from Investoscope is easy. Since v4.0.15, StockMarketEye has support for importing Investoscope CSV files. Simply export your transactions from Investoscope into CSV, then import the CSV file into StockMarketEye.

Export your Investoscope transactions to CSV

For each individual portfolio you have in Investoscope, follow these steps to export its transactions to a CSV file.

  1. Select the individual portfolio from the list on the left-hand side of the Investoscope window.
    Select the Investoscope portfolio to export
  2. Use the menu: File -> Export -> All Transactions to CSV…
    Export all transactions for this Investoscope portfolio.
  3. Choose a name for the file and where you want to save it, such as your Desktop.
    Choose an appropriate name for the Investoscope CSV file.
  4. The CSV file is ready to be imported into StockMarketEye. No changes to the file are necessary!

Getting StockMarketEye

As an Investoscope user, you may not yet have installed StockMarketEye. If that’s the case, you can get the latest version from our website.

Download StockMarketEye

You can try out StockMarketEye free for 30-days. Try out your Investoscope data in StockMarketEye for free!

Import the Investoscope CSV file into StockMarketEye

Importing a CSV file into StockMarketEye is described in our User’s Guide.

Importing Investment Data from CSV Files

However, please take note of the following when importing the Investoscope CSV file into StockMarketEye.

  • In step #2, in the import window, click on the “CSV Columns Format” dropdown and select “Investoscope 3”.
    Choose the Investoscope 3 CSV format when importing into StockMarketEye
  • In step #2, click on the “Advanced CSV Options” button and be sure that the separator is “Comma”. However if you have verified in the CSV file that the separator is a different character (such as a semi-colon), select that character in the Advanced CSV Options window.

When you have finished the import, your Investoscope portfolio has been migrated to a StockMarketEye portfolio. You’ll need to repeat the export/import steps above for each Investoscope portfolio that you want to have in StockMarketEye.

Where To Next?

StockMarketEye has a comprehensive User’s Guide to help you get to know how things work.

StockMarketEye User’s Guide

If our User’s Guide wasn’t enough and you need more help getting started with StockMarketEye, don’t hesitate to drop us a comment here. You can also contact us directly at our support email address: support@stockmarketeye.com

Best of luck with your investments!

Posted by admin | in Documentation | 10 Comments »

Information for Vanguard Users

Sep. 14th 2014

On September 11, 2014, Vanguard announced that they were upgrading their transaction download service. The upgrade affects Quicken users as well as users of other financial software that use the Vanguard transaction download service, such as StockMarketEye. Vanguard has provided detailed instructions on how to update Quicken to work with their upgraded service.

StockMarketEye users who are tracking their Vanguard portfolios in StockMarketEye will also be affected by this change. The import and update from brokerage features for Vanguard portfolios will no longer work in the current version of StockMarketEye.

However, we have a preliminary fix for StockMarketEye and hope to have a final version of it available next week. StockMarketEye v3.3.3 restores the access to Vanguard portfolios. You do not need to update or change your portfolios in StockMarketEye. StockMarketEye will transparently manage the update for you. You will be able to continue using the import and update from brokerage features for your Vanguard portfolio just as you previously did.

Download the latest version of StockMarketEye to get the fix for Vanguard portfolios.

If you have any questions or comments, leave a comment here or contact our support team.

Posted by admin | in Documentation | No Comments »

How to handle the AAPL stock split

Jun. 10th 2014

After the close of trade on June 6th, 2014, Apple Inc. (AAPL) underwent a 7-for-1 stock split. The split was effective for anyone who owned shares at the end of trade on June 6th.

The AAPL split was a standard stock split. The number of shares owned before the split is multiplied by 7, while the share’s price is divided by 7. Thus the market value of your holding remains the same after the split.

The new shares have the same voting rights as the old shares and will continue to trade under the AAPL ticker symbol. Tim Cook, Apple’s CEO said that the split would help make Apples shares “more accessible to a larger number of investors.”

If you own shares in AAPL, there is more than one way of handling this split in StockMarketEye. (Full disclosure: I own shares in AAPL.)

AAPL Stock Split – Manual Entry

If you have not used the brokerage import to create your portfolio, you can manually split the shares of your AAPL holding by entering a new “Split” transaction (StockMarketEye does not do this automatically for you). You can do this by following the steps in the “Entering a Stock Split” page from our User’s Guide.

Note that you should record the split transaction with the date of June 7th, rather than June 6th. The split occurred after the close of trade on the 6th, so the closing price on the 6th does not yet take into account the split. Because of this, if you record the split with the date of June 6th, you’ll have a large spike in your portfolio’s market value chart on that day. Specifying the date of June 7th in the split transaction will avoid this issue.

Via Update from brokerage…

If you created your StockMarketEye portfolio by importing from a brokerage, you should run the Portfolio -> Update from brokerage… menu to pull in the latest transactions from your brokerage. These transactions normally should account for the split and your current holdings (i.e. Prices view) will be updated accordingly. Check your “Transactions Report” to see the details of what the broker did to account for the split.

However, your brokerage may not handle the split cleanly and you may have to make adjustments to your StockMarketEye holdings after the fact. Here are 3 ways that brokerages will account for the split and how they work in StockMarketEye.

1. Using a “Split” Transaction

This is the proper way of handling a stock split. The brokerage simply includes a “Split” transaction when you update from brokerage and that split is applied by StockMarketEye to your portfolio. This is the same as entering the Split details manually in StockMarketEye.

2. Using a “Shares In” Transaction

The brokerage includes a new, “Shares In” transaction for APPL that contains the additional number of shares. These shares are applied (i.e. added) by StockMarketEye to your portfolio so that the total number of shares you own equals the pre-split number of shares plus the new shares from the “shares in” transaction.

This is a less “clean” way of handling the situation as the individual sub-lots in your Prices view for AAPL will not reflect the accurate cost basis. However, the aggregate lot in the Prices view (i.e. the main lot for AAPL in your Prices view that can be expanded to see the sub-lots) will show an accurate cost basis. Thus it still “works”, but is just not as clean as it could be.

Vanguard uses a “Shares In” transaction for splits in this manner.

3. No Transaction Recorded

Your brokerage may not record a transaction at all for the AAPL split. In this case, you’ll need to manually account for the split by following the steps in the “Entering a Stock Split” page from our User’s Guide.

4. Using a “Shares Out” Transaction

As un-intuitive as it sounds, some brokerages send a “Shares Out” transaction for the additional number of shares. When StockMarketEye applies the “Shares Out” transaction, it completely removes the AAPL shares from your Prices view. This is obviously not an accurate way of recording the split. See the next section on how to fix this in StockMarketEye.

E-Trade sends a “Shares Out” transaction.

Fixing the Prices View

If your brokerage uses either the “Shares In” or “Shares Out” method, or another way that does not correctly record a “Split” transaction, you can use the following steps to clean-up the situation in your StockMarketEye portfolio.

1. Delete the “Shares In” or “Shares Out” transaction

Go into the “Transactions Report” and select the AAPL transaction that your brokerage recorded for the AAPL split. Then right-click on it, and select the “Delete from transactions…” item from the pop-up menu. Click OK in the confirmation window.

2. Run the “Synchronize Portfolio with Transactions…” feature

Switch back to the Prices view and use the menu: Portfolio -> Synchronize Portfolio with Transactions… This feature is described in the “Synchronize Your Portfolio With Its Transactions” section of the User’s Guide. It will rebuild your Prices view from the Transactions recorded in the Prices view. Afterward, your Prices view should look as it did pre-split.

3. Manually Add the Split Transaction

In your Prices view, select AAPL and the use the menu: Portfolio -> Split Stock… Enter the 7-to-1 split details and click OK. This will record the proper “Split” transaction and your Prices view will be accurate again.

4. Do not use the “Update from brokerage…” feature for the next 5 days

If you use the “Update from brokerage…” feature in the next 5 days, StockMarketEye will re-import and re-apply the “Shares In” or “Shares out” transaction that you deleted in Step 1.

After 5 days, StockMarketEye will no longer import that deleted transaction and you can use the “Update from brokerage…” feature as you normally would.

Conclusion

Hope this helps you manage the AAPL split in your StockMarketEye portfolio. If you have questions or comments, don’t hesitate to contact our support team.

Posted by admin | in Documentation | 1 Comment »

How to handle the GOOGL/GOOG split in StockMarketEye

Jun. 3rd 2014

On April 2, 2014, Google Inc. implemented a special stock dividend. The dividend looked very much like a stock split and affected all owners of their Class A stock on the date of record, March 27.

In effect, the dividend splits the value of Google’s Class A shares (voting shares) by half and issues a new class of shares, Class C (non-voting) shares. Anyone who owned Google Class A shares (pre-dividend symbol, GOOG) on the date of record (March 27) would receive an equal number of the new Class C shares.

The ticker symbol for the Class A shares changes to GOOGL (from GOOG) and the new Class C shares will trade under the old GOOG symbol.

This may all sound quite complicated, but let look at an example to see that it’s not really so bad.

Effects of GOOGL/GOOG on your Holdings

Let’s say that you owned 20 shares of GOOG on March 27.

On the date of execution, April 3, those 20 shares would change their symbol from GOOG to GOOGL. On that date, your account would also be credited with 20 shares of the new Class C shares trading under the symbol GOOG.

This table tries to summarise those changes:

April 2 April 3
Symbol Shares Symbol Shares
Class A Shares GOOG 20 GOOGL 20
Class C Shares GOOG 20

Effects on Cost Basis

According to Google’s IRS filing, 50.08% of the cost basis on the first day of trading (April 3, 2014) will go to the Class A shares (GOOGL) and 49.92% will go to the Class C shares (GOOG).

So, in our example above, let’s say that the cost-basis of our original 20 Class A shares was $1000 per share. On April 3, the cost-basis of our Class A shares (GOOGL) would be $500.8 and for the Class C shares (GOOG) would be $499.2.

Example
CostBasis/Share
April 2
Percentage Example
CostBasis/Share
April 3
Class A Shares 1000 50.08% 500.8
Class C Shares 49.92% 499.2

How to record this in StockMarketEye

Since the release of StockMarketEye v3.3, you can record this using the Corporate Action transaction. Corporate Action transactions are for recording things such as spin-offs, which are very similar to what Google has done.

Here’s what you need to do in StockMarketEye:

  1. The first thing is to go into your portfolio, locate your Google holding and change the ticker symbol from GOOG to GOOGL. You can read the detailed steps for changing a ticker symbol in our User’s Guide. Be sure to click the button, “Change All Items and Transactions With The Same Symbol” at the end.

  2. In your portfolio, select the GOOGL holding and then click on the menu: Portfolio -> Record Corporate Action… This will open the Enter Corporate Action Details window.
    Enter the details of the GOOGL split.

  3. In the Corporate Action window, first set the “Date” to be April 3, 2014.

  4. Then set the “Cost Basis Change (%)” to 50.08. Leave the “Shares Change (%)” as 100.

  5. Click “OK” in the Corporate Action window to record the transaction. This will adjust the cost basis of your original GOOGL holding (in the Prices view of your portfolio) by 50.08% and you’ll see a new “Corporate Action” transaction in the Transactions report. Note that the purchase price and total value of the original GOOGL “Buy” transaction have not changed.

  6. Now we need to add the shares of the new GOOG holding we received. Click on the “Buy Stock” button in the portfolio’s toolbar.
    Add the SharesIn transaction for GOOG

  7. In the Enter Purchase Details window, change the “Date” to be April 3, 2014. Then change the “Type” selection to “Shares In”.

  8. Change the “Cash Balance” to be “Do not update”. This is required for proper performance calculations.

  9. Then in the “Quantity” field, enter the same number of shares as in your GOOGL holding.

  10. In the “Price” field enter the original purchase price of your GOOGL shares (pre-split price) times 0.4992. So if your original purchase price was $1000, enter 499.2 in the “Price” field. If your original purchase price was $400 per share, enter 199.68 in the “Price” field.

  11. “Commissions” and “Fees” should be 0.

  12. Click “OK” to add the GOOG shares.

  13. And you’re done. You investment in Google is still worth the same as before, but it is now split across GOOGL and GOOG according to the 50.08/49.92 ratio.

Now, let’s hope to see GOOGL and GOOG touch $1000 per share again soon!

(Full disclosure: I own shares of GOOGL and GOOG.)

Posted by admin | in Documentation | No Comments »

Converting from Personal Stock Monitor

Nov. 12th 2012

The developers of Personal Stock Monitor (PSM) recently announced that they are ceasing development (link no longer works, as their website has been taken down) of their software.

Personal Stock Monitor Replacement

Although StockMarketEye and PSM have slightly different feature sets, PSM users looking for a replacement investment tracking software may find that StockMarketEye fits their needs.

The biggest question that PSM users will have when migrating to StockMarketEye is: “How can I get my current data from PSM into yours?” There are 2 answers to that question:

  1. Migrating Portfolios – StockMarketEye keeps your investment data in what we call Portfolios. PSM calls these accounts. In StockMarketEye, a Portfolio is basically a collection of your investments that typically represents one brokerage account. For this type of data, the best way to transfer the data from PSM into StockMarketEye is by using QIF files. Export the data from PSM into a QIF file, then import that QIF file into StockMarketEye. We’ll explain this in more detail below.
  2. Migrating Watchlists – With StockMarketEye, you can keep lists of stocks that you have your eye on. We call these Watchlists. Stocks in a watchlist don’t have any monetary value associated with them; they are simple lists of ticker symbols. The best way to import this type of data is via StockMarketEye’s CSV import. You can export your PSM watchlists to CSV and then arrange to columns of the CSV file to match those expected by StockMarketEye as described here:

    Importing Watchlists via CSV files.

Importing PSM Accounts into StockMarketEye

Note that we always suggest running the latest version of StockMarketEye.

Here are the steps to use to export your data from PSM into a QIF file. Note that you’ll need to do this for each account you have in PSM.

  1. In PSM, select the account you want to export.
  2. Go to the Transactions Register view.
  3. Select the transactions you want to export. If you don’t select
    any, all of them will be exported. If you have items in this view that
    are not actual transactions (watchlist entries, etc), then make sure
    that you select just the transactions.
  4. Use the menu, File -> Export
  5. Select the name of the file where you want to save the data, making
    sure that the filename ends with “.qif”.
  6. Click Ok.

You now should have a QIF file that can be used for export. To do the import in StockMarketEye, follow along with the steps outlined on this page in our User’s Guide:

Import investment data from QIF files

You should note that there are a few pitfalls that you might run into when importing a PSM generated QIF file into StockMarketEye. A few of the users converting from PSM have been kind enough to let us know how their conversion went and we’ve listed a few of their notes and tips below:

  • Make Trial Runs – You can import the data into StockMarketEye as many times as you like, creating as many portfolios in StockMarketEye as you like. Make changes to the data either in PSM or in the QIF file and then re-do the import. You may need to do this multiple times, depending on how the data looks once it is in StockMarketEye. You can also edit the data directly in StockMarketEye after the import.
  • Verification of Imported Data – To verify that everything was correctly exported from PSM and imported into StockMarketEye, we suggest that you perform the export/import while the markets are closed. This way you can more easily compare the values you see in PSM with those you get in StockMarketEye.
  • Quote Servers – In StockMarketEye there is no need to specify country specific quote servers. We handle this transparently. If you want to use Google Finance for quotes, you need to change the ticker symbol to a Google Finance ticker symbol as described on this page.
  • Stock Splits – Split transactions in the PSM generated QIF file are off by a factor of 10. To fix this, you can either edit the value directly in the QIF file (using a text editor, if you’re familiar with the QIF format), or you can edit the value in StockMarketEye’s Transactions view, then use the menu: Portfolio -> Synchronize Portfolio with Transactions to rebuild your portfolio from the transactions, including the corrected split value.
  • Date Format for non-US Users – Non-US users may run into problems with transaction dates due to the way PSM writes dates in the QIF file. If you’ve noticed the dates of your imported transactions are wrong (for example: year correct, but month and date are switched), you can try this: In StockMarketEye’s QIF import window, you can choose the Date Format to use. Typically it should be ‘Auto’, but if you know that the format of the dates in the QIF file is the same as one of the other “Date Formats” (such as “dd/MM’yyyy”), you should select the necessary format in the QIF import window. Another option is: In the Windows Control Panel -> Region and Language, set the Short Date to “MM/dd/yy”, apply the change and re-do your export from PSM. You can switch the Short Date back to what it was before, after the export from PSM is complete.
  • Legacy Ticker Symbols – You may have ticker symbols from PSM that are not recognized by StockMarketEye. You can keep them as is, or delete them in PSM and re-export. If you keep them, StockMarketEye will not be able to get quotes for them, but they don’t harm anything. Non-recognized ticker symbols can actually serve as place-holders for un-quoted items (bonds, preferred stock, etc) as explained in this blog post.
  • Fee Information Missing – Transaction fee information is not included in the PSM generated QIF file. If you’re using StockMarketEye v3.0 or later, you can add this data afterward in the Transactions view. If you have a significant amount of fee data missing, you might consider trying the CSV export method from PSM (but this may require post-manipulation of the PSM exported CSV file to conform to the format required by StockMarketEye).
  • Average Cost Basis – StockMarketEye does not yet support the Average Cost method, so if you use this mode in PSM, you should disable it before exporting.
  • Options – PSM does not seem to include currently held options in the exported QIF file. You will need to add these by hand after the import by following the steps on StockMarketEye’s stock option page.
  • Tip: Remove Folders in PSM before you export the .QIF file. (By dragging each Ticker above the top-most folder.) Then sorting the PSM “Current Holdings” tab by Symbol gives the same order as SME “Prices” tab sorted by Symbol. This makes it much easier to verify correctness of migration by screen check, printed report or by PSM & SME re-exports.
  • Tip: For many reasons, PSM users may wish to migrate PSM records even when the holding of a Ticker has been reduced to zero; or the Ticker has been discontinued. The SME “Prices” tab shows non-zero Holdings. But the legacy PSM Tickers can be migrated and visible in the SME “Reports” tab. In order to re-find such legacy items after migration, it is helpful to annotate them in PSM before .QIF export. One method is to prefix each Name in PSM with easily recognized text. I used “PSM: “. (Without the quotes!)

If you have any other suggestions for this list, don’t hesitate to let us know.

If you have any problems with the imports or any questions, let us know. We’re happy to help get you started.

Posted by admin | in Documentation | 15 Comments »

StockMarketEye on Mac OS X Lion

Aug. 4th 2011

Apple has released the latest version of their Mac OS X operating system. Code named “Lion”, Mac OS X 10.7 is the successor to Mac OS X 10.6 “Snow Leopard” and is promoted by Apple as “the world’s most advanced operating system“.

As many of our users will be updating to Lion in the near future and as all newly purchased Mac computers will come with Lion pre-installed, we’ve put together a few tips on using StockMarketEye on Mac OS X Lion.

Features

All of the current features of StockMarketEye are available under Mac OS X Lion.

We do not currently support some of the new Mac OS X Lion features, such as full screen mode, in StockMarketEye. However, we are planning on adding such features in the future, as time permits.

Java Installation

Mac OS X Lion does not come with Java pre-installed, as was the case in all previous versions of Mac OS X.

It will, however, be installed the first time you run StockMarketEye on Mac OS X Lion. Here’s how the installation works.

  1. Start StockMarketEye as you normally would (double-click the App in the Applications folder or click on its icon in the Dock).
  2. You will then be presented with the following window. Click on the “Install” button to continue.
  3. Mac OS X will search for the approriate Java version.
  4. Once found, Mac OS X will download the Java version to your computer.
  5. It will then install Java.
  6. After Java has been installed, click on the “OK” button and StockMarketEye will start automatically. If for some reason, StockMarketEye does not start automatically, you can start it yourself as you did in step #1 above.

If you have any questions or problems on getting StockMarketEye to run on Mac OS X Lion, don’t hesitate to contact our support team.

Download StockMarketEye for Mac OS X here!

Posted by admin | in Documentation | No Comments »

Update User’s Guide Now On-Line

Jun. 21st 2011

We’ve just updated and refreshed the StockMarketEye User’s Guide.

It includes lots of new screenshots and explanations as well as a number of new sections including:

We’ll be adding more sections in the future. In the mean time, if you have any suggestions for improvements or features you’d like to see better documented, don’t hesitate to contact us.

Posted by admin | in Documentation | No Comments »

Upgrading to version 2.5.0 for Windows Users

Sep. 1st 2010

Upgrading to StockMarketEye version 2.5.0 on Windows requires a few extra steps so we thought we’d outline them here and give a little explanation.

First Uninstall, Then Install

Short Description: The upgrade process is:

  1. Uninstall the old version of StockMarketEye
  2. Install the new version

If you see this window, StockMarketEye has found that an old version is still installed on your computer. In order to proceed with the installation of the new version of StockMarketEye, you will have to uninstall the previous version first.

Important #1: Uninstalling the previous version of StockMarketEye will not remove your data. All portfolios and watchlists that you had before will be available after.

Important #2: Make sure that you have quit StockMarketEye, before starting to uninstall it.

You can find uninstallation instructions here or click on the “OK” button in the window to open them in your browser.

Some users have reported that even after uninstalling, StockMarketEye will tell them that they still have a previous version installed. If this happens to you, look in your C:\Program Files folder to see if a StockMarketEye folder is still there. If this folder is still there, you should delete it (#3 in image below).

Once the StockMarketEye folder in C:\Program Files is gone, you can start the installation of the new version of StockMarketEye.

Why Do We Need To Uninstall First?

We know that upgrading to new versions of StockMarketEye has been difficult for some users. We also want all of your users to run the latest-and-greatest version of StockMarketEye so they can take advantage of all the new features.

So we have simplified the upgrade process for future versions of StockMarketEye. When the next version of StockMarketEye is released, you will only need to click 1 button. StockMarketEye will download and install the new version for you without any intervention on your part. However, in order for this new upgrade process to work, the old version of StockMarketEye needs to be manually uninstalled.

Basically, we decided to make the upgrade process a bit more difficult this time, in order to make the process much simpler in the future.

If you have any questions or problems with the upgrade, don’t hesitate to contact our support team. We’d be happy to help work you through the upgrade process.

Posted by admin | in Documentation | No Comments »

Tracking Bonds, Preferred Stock and other Non-Quoted Securities

Jun. 7th 2010

StockMarketEye can automatically download recent quote data for stocks, ETFs and mutual funds from most major world exchanges.

NOTE: An updated version of this page is available in our User’s Guide.

For some securities, however, StockMarketEye may not have access to recent quote information. Securities such as bonds and preferred stock as well as items such as real estate will not have quote data available. Some mutual funds (such as Canadian mutual funds or some UK mutual funds for example) also do not have quote data available.

You can still include these securities and investments in your StockMarketEye portfolios, however. Here’s how.

Example #1 – Corporate Bond

Example #1: Citigroup Inc issued bond, 5% yield, maturing in 2014.

As our first example, let’s take a corporate bond issued by Citigroup.

The first thing to consider is what ticker symbol you want to use in StockMarketEye to represent this bond in your portfolio. As StockMarketEye does not have access to quote data for this bond, using the Symbol Search will not turn up any symbols. So we need to invent a fake symbol that will represent the bond in our portfolio. For example, in the case of the Citigroup bond above, we might choose CITI2014.

Another option for our example is to use the CUSIP number. In this case we would use 172967CQ2.

You are free to choose any symbol you want, but the key is to choose a symbol that is meaningful to you and one for which StockMarketEye does not already have data. You can verify this by typing your chosen symbol into StockMarketEye’s Symbol Search field. The search results area should be empty.



Now that we have our ticker symbol, we can add it to our portfolio as we would add a normal stock. Click on the “Buy Stock” button in the toolbar to open the “Buy or short-sell a stock” window. Then enter the choosen ticker symbol and other pertinent data.



In the image above, the important fields are highlighted with a red arrow. You can see that we set the “Number of Shares” to be 5, meaning that we are purchasing 5, $1000 par bonds. The “Price” field we set to the purchase price, which in our example is $986.05 per $1000 par bond. Click OK to add the bond to your portfolio.



StockMarketEye warns us that it does not have access to any data for the symbol, CITI2014. We can safely click OK as we will enter the current price quote ourselves.

Your portfolio will now look something like this. We’ve also added a holding of Citigroup stock to our portfolio.



You’ll notice that the “Name” column is empty for our bond. We can add our own name by editing this field. To do this, with the CITI2014 item selected as it is in the image above, click in its “Name” cell.



Then type the name you want to give this item. In our example, we’ve choosen “Citigroup 5% 2014”.



When you’re done typing the name you want, press Return to have StockMarketEye remember it.



Now let’s say that the price of the bond changes. StockMarketEye won’t be able to update the price automatically, but we can edit it manually.

As we did to change the “Name” cell, we can edit the “Last” cell to change the current price and compute the value of our holding. Select the CITI2014 line and click in its “Last” cell, then type the new price. In our example, let’s say the new price is now $989.50.



As you can see in the next image, the prices have updated to reflect the new value of our bond holding.



Update the “Last” cell like this any time you want to bring your bond holding up-to-date.

Example #2 – Canadian Mutual Fund

The same principles from our bond example above can be applied to other security types. Let’s take the Canadian mutual fund, Fidelity Canadian Disciplined Equity Fund. This fund has a “Fund Code” of FID224 so let’s use that as our ticker symbol.



In the “Price” field we entered the NAV.



Now we’ll edit the “Name” cell and set a new “Last” value for the fund.



You can update the “Last” cell value every day or whenever you want to bring your portfolio up-to-date with the lastest prices.

Posted by admin | in Documentation | 2 Comments »

Tracking a Canadian Investment Portfolio

May. 17th 2010

In this post, we’ll show you how you can setup StockMarketEye to use Canadian Dollars and track your stocks and funds from the Toronto Stock Exchange (TSX).

Tracking your RRSP

StockMarketEye can track an unlimited number of portfolios. As a help to get you started, StockMarketEye will automatically create a portfolio called “My 401K” for you. You can delete this portfolio or create others, as needed. For this post, however, we’ll simply rename this portfolio from, “My 401K”, to “My RRSP” to represent your Registered Retirement Savings Plan (RRSP), the Canadian equivalent of the US 401K. If you don’t have an RRSP, you can rename it to something else, such as the name of your brokerage.

To rename this portfolio, double-click on the “My 401K” Portfolio in the list on the left-hand side of the StockMarketEye window. You can also just select the “My 401K” Portfolio there and go into the menu called “Portfolio” and choose Settings. This will open the “Portfolio Settings” window as shown here.

Now change the “Name” field from “My 401K” to “My RRSP”. You can also write something in the description if you are so inclined.

You should also change the currency of this portfolio from US Dollars to Canadian Dollars. Select the Currency tab in the “Portfolio Settings” window. Then scroll up and select Canadian Dollar (CAD) in the list.

Click OK for the changes to take effect.

Default StockMarketEye Currency Settings

By default, StockMarketEye creates portfolios with US Dollars as the currency. You can change this as well as the currency used in the Portfolio Totals view to use Canadian Dollars.

Open the StockMarketEye “Preferences” window. On a Mac you can do this by going to the “StockMarketEye” menu and choose “Preferences…”. On Windows or Linux, go to the File menu and choose “Preferences…”.

In the “General” tab, you’ll see the “Currency Settings” block. There are 2 settings here you can change. The first is the “Currency for ‘Portfolio Totals’ view”. Click on the button labeled “Choose…” and the “Select Currency” window will open.

As you did in the Portfolio Settings dialog, scroll up in the list and select Canadian Dollar (CAD), then click OK. Now do the same for the “Default initial currency for Portfolios”. Finally click OK in the Preferences window for the settings to take effect.

If you now click on the “Portfolios” item in the list on the left-hand side of the StockMarketEye window, you’ll see the Portfolio Totals view. Note that it now uses Canadian Dollars (C$), rather than US Dollars ($).

Finding Canadian Stock Ticker Symbols

You can use StockMarketEye’s built-in Symbol Search technology to find the ticker symbols of the stocks you want to track from the Toronto Exchange (TSX). Just click in the “Symbol Search” field in the upper right corner of the StockMarketEye window and start typing the name or symbol of the stock you want to add. The search results are displayed just below the search field. You can double click on one of the search results to start adding it to your Portfolio.

In StockMarketEye, ticker symbols of stocks that trade on the TSX are suffixed with “.TO”. For example, Suncor, whose ticker symbol on the TSX is “SU” in StockMarketEye is “SU.TO”. Canadian Western Bank on the TSX is “CWB” but in StockMarketEye is “CWB.TO”.

Another change to be aware of is that tickers symbols from the TSX that contain a “.” (period) have the period converted into a “-” (dash). For example, Penn West Energy Trust on the TSX is “PWT.UN” but in StockMarketEye is “PWT-UN.TO”.

StockMarketEye also supports the Canadian Venture Exchange (CNDX). Ticker symbols of stocks that trade on the CNDX are suffixed with a “.V” in StockMarketEye. For example, Alange Energy Corp, which on the CNDX trades as “ALE”, is “ALE.V” in StockMarketEye.

You can read more about finding stock ticker symbols in the StockMarketEye User’s Guide.

A Note About Canadian Mutual Funds

StockMarketEye can track Canadian stocks and ETFs from both the TSX and CNDX. StockMarketEye can also track Canadian mutual funds using Google Finance as the data provider. Some example tickers symbols for Canadian mutual funds are: MUTF_CA:RBF266 and MUTF_CA:TDB911.

Try StockMarketEye Now

Get StockMarketEye Now, and start tracking your Canadian investments today!

Posted by admin | in Documentation | 6 Comments »

Try it for Free!

Try our software, free, for 30-days. No credit-card or email required.
Just download, install and run.

Get StockMarketEye Try it for free!
Available for:  Investment Management Software for Windows 8 / 7 / Vista / XP      Investment Management Software for Mac OS X      Investment Management Software for Linux      Investment Management Software for iOS Investment Management Software for Android