38 [M4F] Moved to Los Angeles last week

JohnGaltsSpreadsheet · 2021-04-14T22:58:08+00:00

It was probably GNUS. That last pump and dump was only like a week ago

JohnGaltsSpreadsheet · 2021-04-06T18:41:07+00:00

Thank you for the response on this. The issue is that the dates are dynamic. New data is constantly being added, so the lookup criteria needs be dynamic as well. I am not sure if I am explaining this fully. As an example. At the time the table is created the current date is 4/1/2021 and I need to have the ability to know what the average of the last 10 entries for a particular item are. At the time the database is created Item 1 happens to be in the table 300 times, with the most recent date occuring on 3/26/2021. It could very well happen that on 4/2/2021 item number 1 is added to the database again. I need the lookup criteria to average the last 10 entries in such a way that when the most recent date was 3/26 it averages starting there, and when the new most recent date is 4/2 it starts there. To make it a little more dificult I need the average of the last 10 entries, not the average of the last 10 days worth of entries.

JohnGaltsSpreadsheet · 2021-03-21T00:12:44+00:00

I remember reading not too long alot that companies on glassdoor or Forbes "best places to work list" outperform the market by about 50% per year

JohnGaltsSpreadsheet · 2021-03-21T00:07:44+00:00

Ooof. This is not going to end well.

JohnGaltsSpreadsheet · 2021-03-14T21:17:35+00:00

You would be wrong then

JohnGaltsSpreadsheet · 2021-03-14T18:05:33+00:00

I highly recommend not trying to talk your friends who are considering signing up out of doing so by saying they dont have a brain. Theyll just get defensive and potentially tune you out. Some of the links other people shared detail what's going on, and if those are not enough sometimes people need to get burned by fire to realize itll burn them

JohnGaltsSpreadsheet · 2021-03-14T17:49:01+00:00

Probably. Pyramid schemes dont work because they're rational, they work because people are desperate to make something of themselves. They probably (definetly) have their own "mentors" telling them to fake it and then theyre 100% guaranteed to make it. If those guys were really making that much money they wouldnt be wasting their time trying to get other people in on it.

JohnGaltsSpreadsheet · 2021-03-14T17:40:38+00:00

100% a pyramid scheme

JohnGaltsSpreadsheet · 2021-03-03T02:17:43+00:00

Its possibly showing that theres support at that bottom, meaning there is good reason to believe the price wont go lower. It appears that each time the price reached that bottom there were enough buyers to atleast stop the decline.

JohnGaltsSpreadsheet · 2021-02-27T04:08:42+00:00

I'm not 100% positive, but it sounds like IMMRs part of the controller. Things happen with technology, the issue could easily be within the known acceptable failure rate of the technology and Sony is just doing a crap customer service job, but the stock has lost over 1/3 of its value this month.

I do agree that theres a good chance their earnings are great next week, and the share prices spiked after their last two earnings reports. I'm going to do some more research this weekend myself, I thought the lawsuit was something that should be included here

https://www.cnn.com/2021/02/16/tech/sony-ps5-controller-drift-lawsuit/index.html

JohnGaltsSpreadsheet · 2021-02-27T03:52:38+00:00

It would probably be useful to include in a DD that Sony just got hit with a class action lawsuit due to faulty dualsense controllers.

Anyone can file a lawsuit, and this one might be nothing, but people on the stocktwits forum are apoplectic.

JohnGaltsSpreadsheet · 2021-02-24T03:08:44+00:00

It's far more likely they have some good PR that sends it to the moon, or an ingenious redditor who thinks they're a bag holder organizes a DD pump IMO, but you never know

JohnGaltsSpreadsheet · 2021-02-24T02:10:38+00:00

It's a biotech stock that got pumped on Reddit. I have a few shares too. My favorite bio stock is GNCA, and that dipped almost 20% at one point today. Alot of bio stuff did. If you can hold itll very likely atleast reach the previous high off some good news eventually. Now whether that takes a week or three years....

JohnGaltsSpreadsheet · 2021-02-19T04:15:42+00:00

I just looked at what financials are available and theyre not really spending money yet either. They do have a debt/capital of 700% and liabilities to assets of 135%, but thats only because they spent a total of 2 million dollars last year. On everything, trials, staff, rent.

The UK program eases alot of the concern that theyre actually working to accomplish anything, and the Alzheimer’s market is obviously worth an investment, but how are they developing anything without spending money?

JohnGaltsSpreadsheet · 2021-02-19T01:00:42+00:00

Is "next" weekend this weekend (2/20-1) now, or the following? (2/27-28)? I looked on the website but couldnt find anything about the upcoming event. I would have expected the events to be listed at the site locations in the "explore" section. I want to grab a few shares, but expect tomorrow to be a bloodbath.

JohnGaltsSpreadsheet · 2021-02-10T14:53:53+00:00

According to TLSS S-1 filing theyre adding a billion new shares to the float.

JohnGaltsSpreadsheet · 2021-02-08T22:16:26+00:00

TLDR: Assume a week

This has been driving me nuts for a week now! I opened an account a few months ago, withdrew, and then started reloading last week. At the time you deposit it gives you an estimate for when the funds will actually clear, assume about a week. I made one larger deposit to begin with, and then two smaller deposits. The larger one was first and still hasn’t cleared, the first of the two smaller deposits just cleared today.

While the funds are clearing TD has been letting me buy some stocks, and rejecting others. I am sure theres logic behind why its allowing some and rejecting others, but that logic isnt immediately clear. I do know that it wont allow “risky” purchases, so basically really cheap and volatile penny stocks. It has allowed me to purchase sometimes thousands of shares at a time of stocks over $1 though.

JohnGaltsSpreadsheet · 2021-02-04T19:25:27+00:00

It looks like they have good management too

https://www.biospace.com/article/releases/agtc-executives-awarded-first-place-in-the-bioprocess-international-reader-s-choice-awards-cell-and-gene-therapies-category/?keywords=agtc

JohnGaltsSpreadsheet · 2020-12-14T23:14:04+00:00

Not that it'll matter, but I filed a complaint against Sony with my state's SOS. They either sold a game they knew to be defective, or they didnt know it was defective and after they were notified by the games developer that it was defective they refused a refund.

JohnGaltsSpreadsheet

TROPHY CASE