Stock Tracking Dashboard and Live Stock Price Quotes Using Excel

Nearly everybody I know uses Excel for tracking the returns in the stock market. Not many however know that Excel can be used for online stock tracking and getting live price information from stock exchanges like NYSE and Nasdaq as well. Here's how. Establishing a connection to the MSN server for Stock Quotes Click on the data tab in the Excel ribbon (in Excel 2007 and later). ...

Continue Reading

Stock Tracking Dashboard and Live Stock Price Quotes Using Excel

Case Shiller Home Price Index and the Base Effect

Posted on 31 July 2009

Case Shiller Home Price Index and the Base Effect
The Case Shiller Home Price Indices are constant quality house price indices for the United States. A number of Case Shiller home price indices exist: A national home price index, a 20-city composite index, a 10-city composite index, and twenty individual metro area indices. These indices were developed by economists Karl Case and Robert Shiller. (wiki) The Case Shiller Index has been one of the most keenly watched indices over the past few months. It has been argued (and perhaps ...
Continue Reading

Comments     

Retirement Planner in Excel

Posted on 04 June 2009

Retirement Planner in Excel
Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the retirement planner in excel here. All of us worry about the impeding retirement. How ...
Continue Reading

Comments     

How This Bear Market Compares – NY Times

Posted on 13 October 2008

How This Bear Market Compares - NY Times
A problem frequently encountered with displaying multiple series with overlapping data points within a single line chart is that they just seem to entangle themselves. To get an idea of all the data point that a series represents, the user has to either mentally segregate it from the rest or click on it to highlight the particular line. The NY Times recently published a chart How This Bear Market Compares that tries to solve this problem by highlighting ...
Continue Reading

Comments (4)

It’s all coming to and end now…..

Posted on 11 October 2008

It's all coming to and end now.....
......and sanity is going to prevail soon. I am an eternal optimist and my understanding is that the extreme volatility seen in the global markets signals that the capitulation is coming to an end. 6 months from today, we will looks back at this point and think what a fantastic opportunity it represented. After the worst is over, the markets will return to a level ...
Continue Reading

Comments     

How the mighty have fallen

Posted on 05 October 2008

How the mighty have fallen
Below is a list of how much the global markets have fallen in the past year. The highs and the lows may not coincide with the beginning and end of the one year period. Data for week ending 5-Oct-08. S&P 500 52 week low: 1,098 52 week high: 1,576 Correction: 30%...
Continue Reading

Comments     

Factors Affecting Real Estate Growth

Posted on 04 October 2008

Real Estate can and does appreciate. And prices can drift downwards too. I would classify the factors that decide on these movements as being: 1) Local (Distance from central business district, prevailing living conditions in that area including offices, shopping malls, parks, entertainment centers, distance from major arterial roads, distance from landmarks such as airports, town halls etc.) 2) Regional or National (Growth rate of a country, Rate of unemployment, Rise in income levels, Rise in populations segment that can afford housing, ...
Continue Reading

Comments (2)

Own, Let-out or Rent – Making of a house

Posted on 21 September 2008

Own, Let-out or Rent - Making of a house
One question that comes to everybody's mind when thinking of investing in a house is whether the investment will be worth it. Over the weekend I worked out a basic model that attempts to work out the financials in three different scenarios - buying a house and occupying it, buying and letting out and thirdly, not buying a house at all. Expectedly, we can see, that buying a house may turn ...
Continue Reading

Comments (2)

NY Times – Home Foreclosure Graph

Posted on 07 September 2008

NY Times - Home Foreclosure Graph
This appeared some time back in April-2008. What is interesting to note is that not only this chart is visually appealing but it does pack a lot of data. The color of the stacks shows the % of subprime mortgaes as a % of all mortgages in an area while the height of a stack shows subprimes mortgages foreclosed as a % of all subprime mortgages in that area. If ...
Continue Reading

Comments (1)

Oiling the World Economy

Posted on 06 September 2008

Oiling the World Economy
In recent weeks Oil has moved down from $ 140 to $ 108. After reaching record highs, some experts now predict that oil will continue to decline and go back to normal. The trillion dollar question is WILL IT? The price that we pay for oil today certainly seems high, especially when one compares them to what the prices have prevailed for the greater part of this century. Once the oil ...
Continue Reading

Comments (1)

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES