Looking for Daily Value of Trades Indicator or Dataset to build my own

I can't seem to find what I'm looking for. Either a daily indicator that gives me the total value (tick-by-tick) of all transactions on the ask (buy) - bid (sell). Example: "(3 buys @ 2.50) - (2 sells @ 1.75) = 7.50-3.50 = $4 on X day, $3.50 on Y, $6 on Z, etc... Or even an absolute value would be helpful. 7.50 + 3.50 = $11 worth of transactions that day, $8, $7, etc... The idea being that daily_volume*avg_daily_price doesn't account for the spread where a single tick could drop a stock 4% but it takes 30 ticks of ask to bring it back. Hope that makes sense.

So far, I've found a ton of indicators derived from daily volume, but none that work price the way I want. VWAP, for instance, gives me the volume at a price, but doesn't differentiate between an ask or bid transaction.

If I could find a tick-by-tick data set to download I could build out my indicator myself and backtest it, but finding those sets has proven difficult too. I haven't even found a simulated one. Building my own would be difficult because it's not exactly a random value within a range to generate...

Open to any ideas, feedback, suggestions, etc... Thanks for the help!

submitted by /u/fomonomo13
[link] [comments] https://www.reddit.com/r/stocks/comments/13s0jyn/looking_for_daily_value_of_trades_indicator_or/
Created 2y | May 26, 2023, 4:20:59 AM


Login to add comment

Other posts in this group

Rate My Portfolio - r/Stocks Quarterly Thread September 2023

Please use this thread to discuss your portfolio, learn of other stock tickers, and help out users by giving constructive criticism.

Why quarterly? Public comp

Oct 21, 2023, 1:20:16 AM | reddit stocks
Tax planning when selling one stock to buy another stock?

When you sell a stock to buy another stock, do you prefer to set the estimated amount of the capital gains taxes aside in a money market or do you think it better to

Oct 18, 2023, 6:20:11 AM | reddit stocks
Retirement Planning's-3 stocks could help power your investment portfolio and make you wealthier by retirement.

Saving for retirement is crucial, but relying solely on a 401(k) might not be enough due to high inflation. Consider investing in growth stocks, especially in the tec

Oct 18, 2023, 1:51:00 AM | reddit stocks
r/Stocks Daily Discussion Monday - Oct 16, 2023

These daily discussions run from Monday to Friday including during our themed posts.

Some helpful links:

Oct 18, 2023, 1:50:58 AM | reddit stocks
Discovery Financial Services (DFS). Any good ?

I’m think this is not a good investment as there is no chatter at all on the 52 week low. They are involved in a class action lawsuits by investors and credit card co

Oct 18, 2023, 1:50:56 AM | reddit stocks
Tax implications of selling one etf for a dividend etf?

Sorry if this is the wrong sub. Let’s say I had $1 million in VOO but I wanted to sell half of it to buy SCHD. It would suck to pay taxes on $500k. So how would you g

Oct 18, 2023, 1:50:53 AM | reddit stocks
Crocs Stock Analysis (CROX)

Hey guys, I did a deep dive into Crocs. In this analysis, I will do a brief breakdown of the company and go over some quantitative data, qualitative data and estimate

Oct 18, 2023, 1:50:51 AM | reddit stocks