StockMarketEye can import brokerage accounts from Charles Schwab.
This allows you to easily track your Charles Schwab accounts along with all of your other investment accounts within StockMarketEye. You’ll gain valuable insight into your net worth and the performance of all your investments in one convenient location.
There are 2 ways of importing your investment data from Charles Schwab:
- Import from a Charles Schwab CSV file
- Import from Charles Schwab using the Advanced Brokerage Import feature
I used to import from Charles Schwab using “direct connect”. What should I do now?
Charles Schwab has officially stopped supporting “direct connect” imports from 3rd party applications like StockMarketEye (as of October 2, 2021). This comes after almost 12 months of extensions and grace periods granted to StockMarketEye users since Schwab first announced their intention to shut down their “direct connect” (i.e. OFX) service.
If you were importing using from Charles Schwab using the “direct connect” method, we recommend that you now switch to use the CSV file import or Advanced Brokerage Import.
If you choose to use the CSV file import, we suggest exporting only the new transactions from Schwab. That is, on the “History” page in your Charles Schwab on-line account, use the “Date Range” to select only the transactions that are not currently in your StockMarketEye portfolio’s Transactions report. Then import the CSV file into your existing StockMarketEye Schwab portfolio.
If you choose to use the Advanced Brokerage Import, we recommend following this link to connect your existing StockMarketEye portfolio to the linked brokerage account:
In addition to handling Schwab imports, there are tones of great features that make StockMarketEye one of the best portfolio tracking apps out there.
Our on-line synchronization service helps you to keep your StockMarketEye investment data in sync between computers and devices.
Unfortunately the certificate used by our synchronization server expired yesterday. (A certificate verifies our identity to the software connecting to our server and is also used in the encryption of data communicated to and from the server.)
This resulted in the synchronization service being unavailable for about 36 hours.
We have now updated our server’s certificate and the StockMarketEye synchronization service is back up and running.
If you continue to have issues with syncing your computers and devices, have a look at these 2 pages from our Knowledge Base:
We apologize for the inconvenience this incident has caused and wish you continued success with your investments.
Hi StockMarketEye Users!
We just wanted to apologize for our slow response to all your emails. We are experiencing a heavy support load at the moment and are getting behind on replying.
Please be patient and we will reply to your email questions as soon as we can.
If you’re using StockMarketEye v4, please see our full User’s Guide for StockMarketEye 4.
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.
- StockMarketEye has companion apps for iOS and Android.
- StockMarketEye has versions for Mac OS X, Windows and Linux.
- We provide a free, on-line synchronization service to keep your data in-sync between any of the apps.
- Get dynamic charts of individual securities, including technical indicators.
- Easy setup by importing your data directly from US brokerages, QIF, OFX and CSV files (including CSV files exported by Investoscope).
- And much more! Take a tour of StockMarketEye for the big picture of what StockMarketEye offers.
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.
- Select the individual portfolio from the list on the left-hand side of the Investoscope window.
- Use the menu: File -> Export -> All Transactions to CSV…
- Choose a name for the file and where you want to save it, such as your Desktop.
- The CSV file is ready to be imported into StockMarketEye. No changes to the file are necessary!
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.
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.
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”.
- 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.
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: [email protected]
Best of luck with your investments!
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.
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.
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.
Google stock splits once in a while. At least that seems to be the case now, after it happened for a second time in July, 2022.
So, when is the next Google stock split and how does it affect your holdings? Let’s look at what exactly happens during these rare events, how they affect your portfolio, and how to handle them in Stock Market Eye.
When Does Google Stock Split?
Google stock has only split twice so far since they went public in 2004. Both times were to make Alphabet shares more attainable to retail investors. While the two instances differed a bit from each other, the end result was more shares in the market at a lower price point.
On April 3, 2014, Google stock split for the first time when they implemented a special dividend. This affected all owners of their Class A shares on the date of record (March 27, 2014).
GOOG vs GOOGL
In effect, the dividend splits the value of Google’s Class A shares (voting shares) essentially in half and issues a new class of shares, Class C (non-voting) shares. For every 1,000 shares of Google Class A (pre-dividend symbol, GOOG) you owned on the date of record, you would receive 998 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.
Google’s second split happened on July 18, 2022. This time around GOOGL split 20 to 1, so you got 20 shares for every 1 share you owned on the date of record (July 15, 2022).
When is the Next Google Stock Split Date?
No one knows when the next Google stock split is going to happen for certain. Based on their history we can assume it won’t be anytime soon. The first one took ten years, and the next one happened another 8 years after that.
Will the price of shares build up more quickly and give us a 6 year split date in 2028? Maybe, they will hold off a bit longer this time and we won’t see another divide until 2030 or later. Only time will tell.
Effects of a Google Stock Split on Your Holdings
All of this may all sound quite complicated, but let look at an example to see that it’s not really so bad.
The 2022 Split
The recent split was pretty straightforward. For every share you held on July 15th 2022, you would have 20 shares on July 18th. The value of those shares would be exactly 1/20th what they were before.
For example, if you had a single share of Google worth $2,000, you would now have 20 shares, each worth $100.
The First Split Was More Complicated
Let’s say that you owned 20 shares of GOOG on March 27, 2104.
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 show 20 of the new Class C shares trading under the symbol GOOG.
This table summarizes those changes:
|April 2||April 3|
|Class A Shares||GOOG||20||GOOGL||20|
|Class C Shares||–||–||GOOG||20|
Effects on Cost Basis
This is where the 1,998 to 1,000 split gets a little more detailed.
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.
|Class A Shares||1000||50.08%||500.8|
|Class C Shares||–||49.92%||499.2|
How to Record The Google Stock Split in StockMarketEye
To enter a standard stock split, like the recent one in 2022, you would find “Split stock…” under the portfolio menu and click to open the window. From there, you simply enter the date and split ratio and click ok. You have the option to leave a comment here.
You’d Treat The First Google Split as A Corporate Spinoff
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:
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.
In the Corporate Action window, first set the “Date” to be April 3, 2014.
Then set the “Cost Basis Change (%)” to 50.08. Leave the “Shares Change (%)” as 100.
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.
In the Enter Purchase Details window, change the “Date” to be April 3, 2014. Then change the “Type” selection to “Shares In”.
Change the “Cash Balance” to be “Do not update”. This is required for proper performance calculations.
Then in the “Quantity” field, enter the same number of shares as in your GOOGL holding.
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.
“Commissions” and “Fees” should be 0.
Click “OK” to add the GOOG shares.
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.
Prepare for a Google Split Down the Line
The recent split brought Google shares down to a very attainable near $100 price point. Now let’s hope to see GOOGL and GOOG touch $1000 per share again soon!
(Full disclosure: I own shares of GOOGL and GOOG)
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:
- 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.
- 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.
- 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:
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.
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.
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.
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.
- Start StockMarketEye as you normally would (double-click the App in the Applications folder or click on its icon in the Dock).
- You will then be presented with the following window. Click on the “Install” button to continue.
- Mac OS X will search for the approriate Java version.
- Once found, Mac OS X will download the Java version to your computer.
- It will then install Java.
- 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.
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:
- Introduction to StockMarketEye (for new users)
- Configuring Columns
- Managing your Portfolio’s Cash Balance
- The Portfolio’s Transactions View
- and more…
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.