FAQ on Google Sheets & Google Finance for Traders

Many of us have used Google Sheets sometime or the other for EOD/RTD data. There are quite a few Screener's out there in the marketplace that are used by retail traders in NSE. One such is the FataFat Stock Screener

There are quite a few things that one can do with Google Sheets and this post seeks to demystify Google Finance for NSE Traders

How do we get EOD/RTD data for NSE by using Google Sheets
Google sheets use a function called GOOGLEFINANCE which is built-in into the google sheets. GOOGLEFINANCE fetches current or historical securities information from Google Finance

How does GOOGLEFINANCE fetch securities information?
GOOGLEFINANCE retrieves data that is stored on Google Servers

Who is the data provider for the data that Google uses?
End of day prices is provided by SIX Financial Information and Intra-day data may be provided by Interactive Data Real-Time Services, Inc.

Syntax Highlighter for Source Code on Blogs - Google's code-prettify

 A few months back, I started sharing my open source codes on my blog and was looking around to find the best means to highlight the code samples.  Sometimes it helps to have code on the blog for a more detailed  step by step  explanation rather than just post a link to the whole code on a github repo.

There are many tools out there which are suited for the task. I finally zeroed in on Google's code-prettify becos of the simplicity of the solution that it offers. 

As the documentation says, code-prettify is "An embeddable javascript that makes source-code snippets in HTML prettier."

This is the way to setup your blogger for using code-pretiffy :

Step 1:   Login to your blogger account , click on Theme -> Edit HTML