Hi people,
New here, so apologies if I'm posting in the wrong area or reposting something that exists (I did do a search!)
Basically I'm looking at how to get detailed stock data into a spreadsheet so I can run some models and do some "paper trading". I've got OHLC data already [thx yahoo finance], but I'm concerned that if I assume I can always sell based on the range between H & L this may be inaccurate due to the volume at the peaks.
e.g. I want to sell at very close to the H, but the volume there is very low.
So ideally I'm wanting data with volumes at the sell values throughout the day. Obviously I can't get everything, but I assume there is a happy medium between OHLC (e.g. once a day) and 1 secondly data (e.g. 21,600 per day).
any tips? links?
Cheers.
New here, so apologies if I'm posting in the wrong area or reposting something that exists (I did do a search!)
Basically I'm looking at how to get detailed stock data into a spreadsheet so I can run some models and do some "paper trading". I've got OHLC data already [thx yahoo finance], but I'm concerned that if I assume I can always sell based on the range between H & L this may be inaccurate due to the volume at the peaks.
e.g. I want to sell at very close to the H, but the volume there is very low.
So ideally I'm wanting data with volumes at the sell values throughout the day. Obviously I can't get everything, but I assume there is a happy medium between OHLC (e.g. once a day) and 1 secondly data (e.g. 21,600 per day).
any tips? links?
Cheers.