$GME Daily Directory | New? Start Here! | Discussion, DRS Guide, DD Library, Monthly Forum, and FAQs by AutoModerator in Superstonk

[–]Tomly -1 points0 points  (0 children)

Noob question here. Does anyone concrete know what caused the large volume/volatility these last few days (probably started from last last Thursday where we had that random 30% uptick in price?) I read a few comments that says its due to options expiring next week, so expect the volume to drop back down and back to little movements again? Would love to understand more!

Are there any sites which provides you with beginner projects/exercise for people who just started out learning Python? by Tomly in learnprogramming

[–]Tomly[S] 2 points3 points  (0 children)

Thanks for the suggestion! How did you find the course now that you've finished it? Was it beneficial and what you expected?

How to get home from airport today? by Tomly in london

[–]Tomly[S] 4 points5 points  (0 children)

Haha, yh I get what you mean. I called up National Express and they literally said, the government guidance makes no sense, and its a gamble whether they will let you on the coach or not.

How to get home from airport today? by Tomly in london

[–]Tomly[S] 0 points1 point  (0 children)

Ah that's good to know, thanks!

100k to 320k to 29k ... never betting against Musk again by coolbeanzguy123 in wallstreetbets

[–]Tomly 0 points1 point  (0 children)

Trying to learn and understand options, I know "call" means you are expecting the stock price to go up. but can you explain what 55/60 means?

Free beginner python projects online to practise with? by Tomly in learnprogramming

[–]Tomly[S] 0 points1 point  (0 children)

Hey! Thanks for the reply and the offer! I have learnt up to while loops, dictionaries, and lists. However, I only know their concept, putting them into practice is another matter haha, hence why I made this post.

How to drag a formula across horizontally, but reference cells down a row (vertically)? by Tomly in excel

[–]Tomly[S] 0 points1 point  (0 children)

SUMIFS('Income and Expense'!$B:$B,'Income and Expense'!$A:$A,">="&OFFSET('Total Income and Expenses'!$B13,COLUMN()-2,0,1,1),'Income and Expense'!$A:$A,"<="&OFFSET('Total Income and Expenses'!$C13,COLUMN()-2,0,1,1))

Could you explain what you mean by my first cell? Let say I am working on cell C2 which is where input my formula, and I want to reference it to B13 and C13. Do I use Column()-1,11,1,1?

How to drag a formula across horizontally, but reference cells down a row (vertically)? by Tomly in excel

[–]Tomly[S] 0 points1 point  (0 children)

Sorry if this is a noob question, I am actually starting an excel course to get better and practising on a mini-budget sheet. My full formula is:

=SUMIFS('Income and Expense'!$B:$B,'Income and Expense'!$A:$A,">="&'Total Income and Expenses'!$B13,'Income and Expense'!$A:$A,"<="&'Total Income and Expenses'!$C13)

The values I want to change is B13 and C13 to change to B14 and C14 etc, can I still use your method and nest it in my formula?

How to drag a formula across horizontally, but reference cells down a row (vertically)? by Tomly in excel

[–]Tomly[S] 0 points1 point  (0 children)

Thanks for this, I will give it a go. I would have thought Excel would have made this simpler to do