Google Finance Part 2

Hi my name is max haynes and this is part two of using google finance in google sheets you cannot actually use it in excel because it’s tied needs to be connected to the internet and google sheets allows it to do that and be able to use that function the google finance function does not exist in excel but i was able to pull up together really quickly a way to

Use these stocks so what you’re seeing right here on the far right and this is a really good way to be able to create stock screeners and be able to kind of look at stocks really quickly so i have right here on the right this is the price of those companies for the past five years in a sparkline so i can see kind of how these companies have performed and then

They’re what i’m looking at here are mostly ritz um wms i believe is williams which might be an oil and gas company so is okay so companies are oil and gas companies but most of these are reits it’s a real estate investment trust but what these companies do what this does here is it pulls up their price i can see the current price of all of these and then i can

Pull up their beta values beta is how well they coordinate to the stock market as a whole so a beta of 1.88 means that if the whole stock market goes up one percent they tend to go up not always it’s not a guarantee but they tend to go up one point eight percent but the opposite is also true it’s a measure of volatility so if the company went if the whole stock

See also  Finance Minister Buggana Rajendranath Picks Holes In Babus Land Scam Amaravati | V6 Telugu News

Market went down one percent they would go down 1.88 so it’s an important thing to consider and how volatile of a stock do you want here i can see the year-to-date price change essentially what i’m looking at that here is is the price today lower than the price was a year ago i when i used this was right during a little bit after the chrono rise pandemic caused

A steep drop in the prices i wanted to find companies that had been doing really well before the pandemic dropped off due to the pandemic and everyone getting scared and then that i would buy into those companies preferably at a cheaper price and i was also looking for so that’s why i had this relative price here because i have their pre-covered price and then

Their current price and their year-to-day change and then i have their earnings per share which is a good metric to follow as well this is the volume and then i have the dividend yield which is really what i cared about in this case i was looking for companies with a really high dividend yield and so still have that and so then i was able to go through narrow

Down these companies figure out which ones i liked which ones i didn’t i actually built a heat map so you can see here if the earnings per share was negative i immediately eliminated those companies it feels real negative it’s a little bit negative i still probably went ahead and eliminated them green means i liked it so what i want to do is really quickly be

Able to look across and see let me see what is how this company is doing and so one of the ones i found here is okay which is antioch they are an oil and gas midstream company they move around natural gas and crude oil and so the way they work does i was able to quickly able to see after i overlaid the heat map that this company is green on earnings per share

See also  Why you should FINANCE your CAR instead of PAYING CASH!! (Current market environment)

They have a good dividend yield i was a one in a pretty high dividend yield a nine percent dividend deal yield was good i was also able to see that it do i can see it in the sparkline but i can also see it on this relative price here and in the year-to-date price change and so i was able to at the time be able to see okay so let me follow the line they’ve had

Really good product or good performance all the way through they’ve been steady maybe even grown a little bit all the while paying a really high dividend coronavirus hit and they fell really hard but coronavirus didn’t really affect their underlying business too much because we still need natural gas in order to heat our homes and things like that and natural

Gas also long-term outlook even though we are shifting to more and more renewables natural gas is the middle man it’s the way that we shift from non-renewables to renewables so i see in the next 10 to 15 years natural gas still being really big i did a little bit extra research on that industry which is an important thing to do is know the outlook of the industry

So i read the reports from exxon from shell and from chevron and bp on what their five to 15-year plan looked like for the energy sector and almost all of them showed a massive increase in the amount of natural gas that they would be producing so those are the producers well this is mid-stream so midstream’s not quite as volatile but you can see it’s definitely

See also  RBI guidelines on Small Finance Banks, Know what On Tap Licensing means, Current Affairs 2019 #UPSC

More volatile than the stock market as a whole it has a two for a beta so you know it’s gonna move twice for uh two percent for every one percent the stock market does but the nice thing here was it was midstream so it wasn’t quite as volatile and they’re moving around so if the producers are producing more natural gas they need oniok to be able to um send that

Natural gas and move it around so i’m going to bought into that company um i don’t know where exactly but around this area and as you can see it has increased since then so it was a good idea still hasn’t reached pre-covered levels it may never reach pre-covered levels but at the time it was a good buy especially for the short term and i liked it for the long term

Because it was paying a good dividend so even if the price held constant i was still making money even though the price of the stock didn’t necessarily go up but this is a really good way that you could go ahead and use excel to create a stock screener and find stocks that you like so hopefully you learned something today and best of luck

Transcribed from video
Google Finance Part 2 By Max Haines