Checking Bid/Ask price

Anyone knows how to find out the bid/ask price for a particular pair at certain day and time in MT4?

You cannot. The history data for each bar on your chart comprises 5 values, Open, High, Low, Close, Tick count and the datetime of the ope of the bar, and these are Bid values. The Ask is not stored at all.

I wanted to put in a formula on my spreadsheet to calculate the P&L for the cross pairs. But cross pairs requires the bid price for the quote currency at the point of time when I close out the trade.

So what I require is only bid price. Is it possible?

MT5 shows historical spreads; here's a post with an indy attached.

Thank you FiatFap. But I'm still with MT4. RaptorUK, if I only need the historical Bid only, is there a way to find out?

Thanks in advance.

Yes you can get it from the Bar data, but if you want a specific time to the second you cannot get it, the best you can do is select OHLC or a combination of those from an M1 bar.

First you need the bar number, you use iBarShift() to get that, then use this bar number to get the iHigh(), iLow(), iOpen() and iClose()

I see. Like I said, I'm trying to put in the formula in my spreadsheet to calculate crosses.

Do you have any better way to this?

Thanks.