As you know, most of the EOD data available have only OHLC price. I used to do back-testing using the Close price as both bid and ask. however, in real world, the bid and ask spread is huge and the bid/ask quantity is also never constant. Above that, the bid/ask price changes with every shares sold/bought. Therefore, my earlier back-test could never be implement in the real world. What approach should i do to get/estimate ask/bid price for backtesting for OHLC data?
closed as too broad by olaker♦ Aug 9 '13 at 7:20
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
If you want to backtest with closing prices, the best bet is to add a slippage to the trade price. Note, however, that transaction cost modeling is a large field within quantitative finance and there is no simple solution to estimate this.
There is a recent paper with a procedure to estimated the bid/ask spread from a series of daily high/low prices. Link: http://www3.nd.edu/~scorwin/papers/high-low_spreads.pdf