Hi Guys,
i am looking for a formula that will help me do a bid-ask spread, the trick is that each bid must be subtracted by the latest ask above, and i have 4000 rows so its impossible manually. how can i do it? please help
01 ASK 14
02 ASK 22
03 BID 31
04 BID 11
05 BID 14
06 ASK 22
07 ASK 11
08 BID 11
09 AsK 41
10 BID 23
11 BID 31
i am looking for a formula that will help me do a bid-ask spread, the trick is that each bid must be subtracted by the latest ask above, and i have 4000 rows so its impossible manually. how can i do it? please help
01 ASK 14
02 ASK 22
03 BID 31
04 BID 11
05 BID 14
06 ASK 22
07 ASK 11
08 BID 11
09 AsK 41
10 BID 23
11 BID 31