Pick of The Year 2018 Contest

[JohnHenry]

Do we want to play this year?

[mimo_100]

I have a few picks and I am ready to play.

[billyjoe]

John Henry, I pick SHLD short. Thank You.

----------------billy

[mimo_100]

John Henry, I pick CBWTF. Thank you.

[tiedyed1]

John Henry, thanks for asking (and running this game)!

My 2018 Pick Of The Year is TRVN

Thank you.

[Louetta]

Yes, thanks for asking.

[Phoenix7]

John we are all set to enter our picks , Once again your hard work in scoring all the picks is deeply appreciated! THANK YOU!

[wifwif]

John Henry, thank you. I think I will try it with XXII. Thanks.

[JohnHenry]

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.

[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

[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

[blindsquirrel]

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

[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!

[Karel]

Yes, please!

[Paco]

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

What are the rules ?

Are stocks under $5 allowed, etc..?