I've finally got the new data downloaded and am getting the pairs I want to work with now extracted and ready for cleaning.
In the past I've worked with smaller consecutive batches of data that fit into excel... this time around the sample size is too large for excel. Has anyone ever cleaned bad ticks with a SQL string? I think it would be pretty straight forward but that's what I always think right before a train wreck that ends up taking 12 hours to fix...
Thought I would get some input before I jumped into the tar...
In the past I've worked with smaller consecutive batches of data that fit into excel... this time around the sample size is too large for excel. Has anyone ever cleaned bad ticks with a SQL string? I think it would be pretty straight forward but that's what I always think right before a train wreck that ends up taking 12 hours to fix...
Thought I would get some input before I jumped into the tar...
Trade Small. Be Patient. Learn to Survive.