"I want to sell at very close to the H". The high isn't known until the bar is closed, regardless of time frame, and by then it's too late.
Weblink has intraday data for ASX stocks.
Most liked posts in thread: Detailed Stock Data to Excel
Appreciate the help despite appearing like a nub.
Any idea on how much volume $$ I would want to see at a given value to assume my sale of. Lets say $50k, went through? I'm presuming I can't assume if the volume is equal to my sale I get the sale...
*the smaller the ratio: my trade size: $turnover per hour, then smaller the slippage. Your average hold time will also influence the impact of such slippage on profitability. Day trading 50k of BHP would create a small but noticeable impact on profitability, I'd imagine.
Thanks, I must admit I assumed a trade size as small as $50k would go unnoticed in a market as large as BHP.
I'll have a search on this forum now you have given me the terminology I was missing. But do you know of a book or alternative resource that would help me understand the fundamentals of slippage and impacts of trading on underlying market trends?
1. add a certain amount to brokerage costs
2. if x is your target sell price, run your backtest on x-.05 or whatever you choose.
Or you can just trade your system in real time and see how profits compare with backtests and just understand there will be approximately that amount of difference. Don't spend too much time on this aspect unless you are trading very short time frames and every tick is important. If that's what you're wanting to do, then you need to know bid/ask prices intraday, and it gets complicated. Howard Bandy's books worth looking at, although he uses Amibroker for the most part.
Yahoo data, being free, won't let you know if the transaction occurred at the bid or ask price.
You would need to refresh a few times during the trading day to get your price range, then just save the data to a new sheet.
So I checked out your original thread.
I couldn't get to work on my work pc (seems to bring back the codes in column A, random html code in column B & nothing else) but I'll try @ home tonight see if it works better without firewalls etc. I'll also try once the market opens in case it needs live data to work.
thanks for sharing.
You will only get to know how these factors affect your particular trading by gaining more experience (through watching and doing).
You should definitely learn about minimum price step of different priced stocks and about spread... so take a look at CBA (~$75), AMC (~$14), PTM ($6), HSO (~$2), FXJ (~80c) and see how easy or hard it is to trade the "last" price vs sell at the highest bid.