2015 Beyond Portfolio Challange

[flipstah]

I can't buy shit with 5% gains.

[Sugarphreak]

...

[TomcoPDR]

Sorry if it's been asked or covered. Sugarphreak... building my own Google finance sheet, how does the formula work for dual US/Canadian listed stock, but I want the Canadian price? Please.

[Sugarphreak]

...

[TomcoPDR]

Originally posted by Sugarphreak


Currency formula for the exchange is as follows:

=GoogleFinance("CURRENCY:USDCAD&quot

From there you can just use it ias a multiplication factor

For instance if you wanted the CAD price for Tesla:

=GOOGLEFINANCE("NASDAQ:TSLA","PRICE&quot*GoogleFinance("CURRENCY:USDCAD&quot

Thanks Thanks

Oh you know, just tracking my losses

[realazy]

Tomco said dual listed, so just query the TSX symbol stock instead of the NYSE or NASDAQ one.

[TomcoPDR]

Originally posted by realazy
Tomco said dual listed, so just query the TSX symbol stock instead of the NYSE or NASDAQ one.

Played around with it... just .TO

So Potash (for example)... POT.TO (for TSE price)

[flipstah]

3rd? Fml.

[Sugarphreak]

....

[Sugarphreak]

...

[flipstah]

Lawlz 2nd. Should've put real money.

[mazdavirgin]

Where is my oil price recovery. That's what I get for investing everything and hoping for a recovery.

At least my real investments are doing well. Gogo ETF's

[oz388]

Originally posted by Sugarphreak
Well Beyond... turns out you are all just awful at this.

Congrats on losing nearly a half million dollars, tisk tisk

https://docs.google.com/spreadsheets...FWBwys/pubhtml

most are too young to be good at stock picks

[themack89]

Originally posted by oz388


most are too young to be good at stock picks

That's funny.. I'm pretty sure the top 3 are the youngest in the competition lol.

[oz388]

Originally posted by themack89


That's funny.. I'm pretty sure the top 3 are the youngest in the competition lol.

maybe u r right...

[Env-Consultant]

Originally posted by mazdavirgin
Where is my oil price recovery. That's what I get for investing everything and hoping for a recovery.

At least my real investments are doing well. Gogo ETF's

Oil Price Recovery?......

[oz388]

Originally posted by Env-Consultant


Oil Price Recovery?......

Sorry it's not happening any time soon, let's hit 2008 low first.

[ExtraSlow]

So I am last place today. Grrrreeeeeaaaaatttttt.

[Env-Consultant]

Originally posted by oz388


Sorry it's not happening any time soon, let's hit 2008 low first.

Agreed - hence the repetitive "wait for it" Homer Simpson gif. Suspect he might have to keep going for a lonnnnng while!

[mazdavirgin]

It's even worse today. Going for last place at this rate.