All articles with 'portfolio tracker' Tag

11 Excel Trackers & Templates to help you Rock 2011

Published on Dec 28, 2010 in excel apps
11 Excel Trackers & Templates to help you Rock 2011

We are just a few days away from 2011. New year always brings hope, cheer, joy and revitalizes us. So naturally many of us embark on journeys with new goals, resolutions, things to do.

Naturally, Excel can help us better manage the new year. In this post, I am featuring 11 templates so that you can have a rocking 2011.

Continue »

Get Stock Quotes using Excel Macros [and a Crash Course in VBA]

Published on Jun 2, 2010 in Learn Excel, VBA Macros
Get Stock Quotes using Excel Macros [and a Crash Course in VBA]

Have you ever wanted to fetch live stock quotes from excel? In this post we will learn about how to get stock quotes for specified symbols using macros. We use Yahoo! Finance API to fetch the stock quotes and other information related to a company using excel macros. Along the way, we will also learn various interesting things about Excel VBA. Think of this post as a crash course in VBA.

This is a guest post by Daniel Ferry.

Continue »

Tracking your stock portfolio using Google Docs

Published on Sep 12, 2008 in ideas, Learn Excel, personal finance
Tracking your stock portfolio using Google Docs

By integrating services like Google Finance, Search in to spreadsheet functions, google docs has paved the way for endless possibilities. Google spreadsheet function GoogleFinance() can be used to build stock portfolio tracker sheet that can fetch historical stock quotes to tell how your money is doing. Click here to see the stock portfolio tracker sheet […]

Continue »

Get Stock Quotes in Excel

Published on Jun 24, 2008 in america, hacks, Learn Excel, technology

While trying to spell check one my sheets I have learned this cool trick to fetch real time stock quotes without any webqueries or vba or anything. First enter the stock code in a cell (this works for US stocks only), for eg. AAPL for Apple, MSFT for Microsoft etc. Then ALT+CLICK on that cell, […]

Continue »

Mutual Fund Portfolio Tracker using MS Excel

Published on Apr 18, 2008 in Featured, ideas, Learn Excel, personal finance, technology

Would you like to spend next 5 minutes learning how to create an excel sheet to track your mutual fund portfolio? Download the mutual fund portfolio tracker excel workbook now. [Download Excel 2003 compatible version here] NOTE: File updated on 7-FEB-2012 to fix errors. Download again if you need to. We will use 2 simple […]

Continue »