Tracking your data with google sheets

You can keep track of your stocks using formulas in google spreadsheet.

Let me try and give you some of the formulas:

• Get the scrip code from any website (you can use http://money.rediff.com)
• Assume you put the scrip code value in column B of the spreadsheet (Assume column B and row 3)
• For Last Traded Price, put the following formula: =GoogleFinance(B3, "price")
• For the percentage change (for the day) use the following formula: =GoogleFinance(B3,"change")
• For the 52 week low, use: =GoogleFinance(B3, "low52")
• For the 52 week high, use: =GoogleFinance(B3, "high52")

Refer to the snapshot from google spreadsheet below:

   
You would have noticed that the change (percentage change) column is red in color for negative return and green for positive return.

How do you achieve it?

• Go to column header and right click
• Select "Conditional formatting"
• Add a new rule
• Add rule like "If text contains" and value "-", then make it red
• Add rule like "If text does not contain" and value "-", then make it green 

Hope this helps.