23 September 2016

A simple Stock Screener using Google Sheets for Intra Day Trading


So here goes the link:

https://docs.google.com/spreadsheets/d/17lBm-OU1Yv9UZ7VT26eB2TqgDy2NMcrHVohK4CqmWA8/edit#gid=0


In case you want to make any modifications to this google sheet, maybe add some more scrip's or delete some scrips, you have the following options: 

Method 1:
Go to Row # 2. Click on the various columns and copy the formulae. Paste it on your google sheet. Apply this formulae across all the cells in that given column




Method 2:
Login with your Gmail account. Go to the Main Menu of the Google Sheet. Click on File->Make a copy. This will create a copy of the google sheet "Intraday FnO Underlying" in your Google Drive. Now you can edit this new google sheet directly from your own Gmail Account. You can also add/delete rows and make any modifications as you deem necessary.

The screenshot below will provide he necessary guidance:



2 comments:

  1. Thanks Pavan.This is really useful to filter the stocks in realtime.

    ReplyDelete
  2. Now, we seek here not to prove our trade deficit benevolent,What are forex trading signals? or without adverse impact. But the data do temper our perspective.

    ReplyDelete