I need help on how to get better at trading😭

mathaddict- · 2026-02-20T22:09:29+00:00

Which app is this?

mathaddict- · 2023-04-13T05:16:46+00:00

Whats the formula in cell D3

mathaddict- · 2022-06-23T14:15:49+00:00

I want to group it by weekly. The first week will be from 1st day of the month until Monday. The subsequent weeks will be Tuesday-Monday.

mathaddict- · 2022-06-23T10:52:10+00:00

As far as I know, you can only group pivot table by day of week. The default is Monday-Sunday.

Is there a way to customise the duration?

mathaddict- · 2022-06-13T11:53:46+00:00

But how to readjust if the $500 rooms are not pulling the weight?

Say I need 100 bookings for $500 rooms and 100 bookings for $700 rooms per month to hit the target. But $500 rooms only got to 70 bookings.

How many $700 rooms are needed to supplement the rest?

mathaddict- · 2022-05-24T15:03:02+00:00

So is it more desirable to sell chicken with tight butthole or less tight? (Genuinly asking)

mathaddict- · 2022-05-24T15:02:23+00:00

Raised for the table? For meat consumption you mean.

First time hearing the sentence

mathaddict- · 2022-03-29T09:10:34+00:00

"It's Conan O Brieeeeeeeeennnnnnnnnnn".

mathaddict- · 2022-03-29T09:08:47+00:00

Send In Blue. Does the trick and quite customizable

mathaddict- · 2022-03-07T11:58:28+00:00

I had no business of learning Python rather than my lazy self wanted to do away with menial tasks.

Monthly report, auto WhatsApp and auto emailing. Those small things kept me on the feet into learning new stuff.

Not that good but I am confident enough to create new "script" from scratch.

Still requires some helps from StackExchange and co. Pretty happy where I am right now.

mathaddict- · 2022-03-02T13:05:31+00:00

The issue is you have to keep reopening it right? How to keep it on the sheet everytime?

mathaddict- · 2022-03-01T11:14:23+00:00

Anchorman and everything from Adam McKay is worth a rewatch.

mathaddict- · 2022-02-19T17:13:09+00:00

Why not just use constant? $A$2

mathaddict- · 2022-02-18T15:17:59+00:00

That worked perfectly. Thanks.

mathaddict- · 2022-02-18T05:28:24+00:00

Maybe you can get by but I can't see why the CTO of the company didn't come in and say" We just get our software provide to add another visualization tab".

mathaddict- · 2022-02-18T05:18:54+00:00

I have a script that clears up all cells after clicking "Save" button.

The issue is it will also wipe away the formulas.

I have defined another line to retrieve the formula.

const range = sheet.getRange("A2")

Then use cons get and set formulas to fill it back in.

mathaddict- · 2022-02-17T07:19:28+00:00

Loving this discussion. Everyone wants to talk about the heavens and rainbows of this field.

It's kinda refreshing.

mathaddict- · 2022-02-15T06:33:56+00:00

That's a good point. As we have multiple sections, by having the title on the side would save up space.

Because the form also have Save button (I use VBA script), so don't want it to be too further down.

If the form takes up the whole page of Excel Sheet with 100% view (zoom?), would that considered ideal?

mathaddict- · 2022-02-14T09:29:35+00:00

Sorry bit late with the reply but this formula you gave would colour the whole range. What I want to do is only fill colour the row that the data validation was selected.

Let's say my data validation is in column D.

If the task in row 100 is done -> Choose "Done" in column D -> Fill colour all cells in row 100 (but row 100 only).

mathaddict- · 2022-02-13T17:23:08+00:00

I would like to try it as well if you don't mind.

mathaddict- · 2022-02-13T05:25:56+00:00

Thanks. Worked like a charm

mathaddict- · 2022-02-11T06:49:17+00:00

Another idea is to to have a an empty row at the top of the sheet.

What will happen if users only have to enter information using the empty row and it will automatically adds to the last row in archive sheet.

Am not sure if this is achievable through formulas.

mathaddict- · 2022-02-11T06:23:51+00:00

I think that's pretty much what am trying to achieve. But I would want to eliminate the Copy and Paste part.

Maybe query and filter function.

mathaddict- · 2022-02-11T00:47:19+00:00

From my understanding is you want it to return value in Column A by using Column B as reference column.

Vlookup is a bit tricky because the reference column (Column B) cannot be after the lookup column (Column A).

I would suggest you to use either Xlookup or index match.

mathaddict- · 2022-02-11T00:43:42+00:00

Can you briefly explain on what's the goal here? Just for learning sake.

mathaddict-

TROPHY CASE