Tesla, TSLA & the Investment World: the Perpetual Investors' Roundtable

[wipster]

It's too much work updating the stock price in excel. And it costs money. I'm at my 3rd keyboard now.

Anyone know a way to autoimport a live stockprice from somewhere into an excel cell? Don't have to be real-time. A one minute delay or something would be fine.

Serious question.

Try this:

 

[MP3Mike]

Dang... Do we know what TSLAQ did to Sandy? I'm guessing accusing him of being in bed with Tesla or something?

The Twitter thread that came from is here: https://twitter.com/montana_skeptic/status/1294831104273395712?s=20

 

[perwis]

Here is a list of some 15-890 baggers over 10 years. I think Tesla will definitely be on a similar list in the future. (From Peter Lynch’s book “One up on Wall Street”.)

 

[Curt Renz]

Benzinga - half hour ago: Tesla's Gigafactory Berlin Approved For Next Phase Of Construction.

 

[Nocturnal]

Dang... Do we know what TSLAQ did to Sandy? I'm guessing accusing him of being in bed with Tesla or something?

The typical TSLAQ conspiracy theories and slander I'm sure.

 

[StealthP3D]

the problem i always worry about is these deals being tailored to conveniently exclude Tesla. It's somewhat less likely at the Federal level, but I absolutely wouldn't put it past certain state legislatures.

I think you worry too much if you worry this would harm Tesla's natural growth trajectory. Because Tesla doesn't depend upon government subsidies to sell their vehicles and their lead over other manufacturers appears to be growing, not shrinking. With Tesla leading the charge to lower the cost of EV's, it becomes more and more difficult to tailor a subsidy to exclude Tesla anyway.

 

[ggr]

It's too much work updating the stock price in excel. And it costs money. I'm at my 3rd keyboard now.

Anyone know a way to autoimport a live stockprice from somewhere into an excel cell? Don't have to be real-time. A one minute delay or something would be fine.

Serious question.

Excel has the functionality (at least on Macs) but I have no actual experience with it. It appeared in an update within the last year, the only reason I know about it. I asked its help function for "stock information":

 

[Artful Dodger]

That's 1M chairs traded from 15:15 to 15:30 hrs.

FOMO much? Cowboy Poker?

Cheers!

 

[Prunesquallor]

Current versions of Excel have a way to do it: How to view current stocks prices and other quotes in Excel

Very nice. Thanks. Works.

 

[Big Time]

The Twitter thread that came from is here: https://twitter.com/montana_skeptic/status/1294831104273395712?s=20

He blocked me long ago lol what’s it all about?

 

[Off Shore]

On the island sub topic

I heard this w/e that Vieques, small island off Puerto Rico, has no federal tax, and one can get 70 percent of normal social security

Yeah, and think nothing about the fact that the US military used Vieques for decades as a firing range.

 

[SOULPEDL]

Speaking of burning holes in my pocket... If income taxes go higher next year, should I pull some cash out and just bite taxes this year? No capital gains to pay (IRA) so treated as ordinary income. (It also spread it out a bit - FDIC.)

Or maybe my question is, what do you think will be taxed higher in 2021: Income, Cap Gains, or Electricity perhaps?

 

[ByeByeJohnny]

Thanks for all the excel tips. I know I could have googled it but I did maybe two years ago when I started and nothing then. Seems like others appreciated knowing too.

So are we opening in the 1900's or the 2000's tomorrow?

 

[Rammstein]

One weird side effect: all my friends think I'm like a Warren Buffet now because I was rambling to buy $TSLA stock since 2013.

Sounds like you have good friends. My friends just think I’m lucky. That’s how they rationalize it to themselves. I always tell them back that maybe I’m just good at seeing market trends and I saw Tesla’s future product roadmap and assigned a PE ratio to that.

 

[Prunesquallor]

The Twitter thread that came from is here: https://twitter.com/montana_skeptic/status/1294831104273395712?s=20

Oh, look who the alleged offender is. What a surprise.

 

[Artful Dodger]

Hate to say it, but at this pace we could end up with a double century gainer today.

 

[Hock1]

Qualcomm had a 2:1 and a 4:1 split in the same year. I didn't start selling until after the second split.

Microsoft had 9 stock splits over a 16 year period between 1987 and 2003 (seven 2:1 and two 3:2). I held through all but the last one. It was pretty amazing to watch the share count grow over those years.

Even with the 5:1 split coming up, TSLA will still have less than 1B shares out. Currently TSLA has 2B shares authorized. If they had done a 10:1 stock dividend, I think that would have come uncomfortably close to the amount of shares authorized. I could be wrong, but I believe it takes a shareholder vote to approve the authorization of additional shares. If so, I believe additional authorized shares will be done with next proxy. to allow for additional (dividend) splits.

 

[StealthP3D]

It's too much work updating the stock price in excel. And it costs money. I'm at my 3rd keyboard now.

Anyone know a way to autoimport a live stockprice from somewhere into an excel cell? Don't have to be real-time. A one minute delay or something would be fine.

Serious question.

This is the coolest feature of Excel and it's super easy. Just type the ticker symbol in a cell and change the data type to "stocks". It might even do it for you. Then it displays the stock price updated in near real-time. You can then use the charting functions to create customized charts that update in near real-time.

 

[H Mak]

This is unbelievable. I'm just sitting here getting richer by the minute.

 

[Curt Renz]

My brokerage's trading platform has been down all day. So I had to check my account through their website.

What I found is awful. My taxes will be humongous. And I'll again have to go through the nuisance of updating my GTC order, which prevents them from lending my TSLA shares to short sellers.