Is there a way to get the total number of bids and asks in Pi and do some math based on that?

I want to get the total number of bids and asks i.e, total buyers and sellers. Based on those numbers I need to calculate the ratio of it. Is this possible in zerodha pi or suggest any other methods/ways to achieve the same.

it is not possible at all.

can I link the stocks from Pi to excel and there I would get the bids and asks. So there I could code for it right?

I have heard about this process but never did it, I don’t know anything about this.

Yes… right click in Pi… click link to excel