Don’t have the budget for a real stock screener?
Just sign up for a Google account.
If you do not already have a Google account, create one. If do already have an account, log into it and go to Google Finance.
You are going to see various cells here, which you can type into. These cells are a very important part of the process.
Something else that is very important is syntax. Google has a special language for this that you will need to be aware of, so keep this in mind.
To find stock prices, you need to type specific words into the cells that you will see on this page. Google has syntax rules that you will need to follow.
Use Google for help
You can visit Google Help for a full and lengthy list of all the different syntax – this is what you are going to want to type in to find the specific information that you are looking for. There is a simple version of how to use the syntax – this can help you form some basics.
You always enter Google Finance (together as one word) with an equal sign in front of it. You enter this before anything else, each time you want to find something.
After writing this you use parentheses – place them around everything else you write. Inside the parentheses are going to be quotation marks.
You can use this syntax to find the price change. Or, you can type something into a cell to find information about the history of the stocks.
You can gather data from various places and have it all in one place – your spreadsheet. Here is the function that you need to use in order to do this: =importData()
However, the parentheses in the above function are not to be kept empty. Inside the parentheses, and again inside quotations, you will need to place the URL that you are bringing into the spreadsheet.
Various types of files can be put into the spreadsheet. Once you use the function mentioned above, you will get results and certain information.
Learn more about spreadsheets
You will learn about the symbol, name, change, volume and more of the stock that you asked about by using the function. The information that you get will be provided to you in a specific order, so make sure you are aware of this as well.
On the Google Finance page, click on the portfolio link. After this you can download the spreadsheet into excel. You can still bring it back online if you would like to at any time.
In conclusion, creating an online screener certainly requires following direction, learning the language used to get the results, and some work.
However, it is definitely more than worth it in the end. There are so many great things that come with using the internet, and especially Google Spreadsheet, to create this.
There are benefits you just could never have if you tried to screen stocks in some other way.
With this online screener, you have a convenient way to find out about stocks – a way that is fast, simple (once you get it all set up), and all in one place for you to see anywhere in the world.