Pick of The Year 2018 Contest

[blindsquirrel]

My pick - OLED

Might be a good one there. Very low debt, good profit margin, and in a good industry.

[mmaarrkk88]

My pick - OLED

[Phoenix7]

Well I have to stick with a Marijuana business related stock ......KSHB LONG Thank You! And let the GAME Begin! You may be in doubt , but Marijuana has that clout! Perhaps a RAP song is in order lOL

[Gary611]

So, the strategy is penny stocks, i am going wit IHRT. I love the app, can listen to my favorites all ovrt the country.

[blindsquirrel]

My 2018 pick is MIDD. I'm interested to see these post-tax-break earnings from all of these low-debt companies. They've run profitably for years at the old rate, what will they do with all of that extra profit?

[blindsquirrel]

Thank you John Henry...I will go with GLGI

You are a closet penny-stocker!

[mrmarket]

Thank you John Henry...I will go with GLGI

[jiesen]

wow

My pick of the year is Bombardier

BDRBF

long.

now that's an interesting pick!

[Paco]

My pick of the year is Bombardier

BDRBF

long.

[Paco]

Yep.
I'd like to play. I have some good picks.

What are the rules ?

Are stocks under $5 allowed, etc..?

[Karel]

Yes, please!

[jiesen]

There is not a direct formula in Excel anymore. Easiest way should be using (Google Sheets') GoogleFinance function (plus the Index function if you want to fetch a past quote and not just the current one).

Do some googling for more info.

Salud

Great tip, S3! I've been looking for solutions to my Yahoo data addiction issues, and this may be just what I needed.... thank you!

And I'm also looking forward to another year of great POTY competition! Thanks for keeping it going, JH!

[blindsquirrel]

Love to play again this year. I have my 2018 stock ready to go.

[say33]

Hello,
I was using an excel formula to pull the quotes from Yahoo Finance API. Now Yahoo blocked access to the API.
Does anyone have a formula they are using to share with me?

There is not a direct formula in Excel anymore. Easiest way should be using (Google Sheets') GoogleFinance function (plus the Index function if you want to fetch a past quote and not just the current one).

Do some googling for more info.

Salud

[mimo_100]

Hello,
I was using an excel formula to pull the quotes from Yahoo Finance API. Now Yahoo blocked access to the API.
Does anyone have a formula they are using to share with me?

Let me start a new thread for the contest with rules. Please stand by for a week or two.

Maybe MrMarket can share his format

http://www.mrmarketishuge.com/showthread.php?3637-The-MR-MARKET-Stock-Portfolio&p=129225#post129225