[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Excel Help - For Lists of Stocks



PureBytes Links

Trading Reference Links

Commercial sort routines usually provide the option of eliminating duplicate
rows or records.  Excel's sort does not provide that option, strangely
(maybe not so strangely, given the novice developers @ Microsoft).

Have looked high and low, but can find no script, no macro that can do this
simple task.

- I start with a list of stock symbols that have screened for volatility,
price, float, liquidity. List has about 1030 symbols currently.
- To this I add new symbols as I find them.  Must eyeball through the list
of 1030 symbols to avoid duplicates.  This is a real pain in the rear and
subject to eyeball error.
- What would be a time saver and error preventer, is a sort that eliminates
rows having a duplicate in the specified symbol (sort key[s]) column[s].

Does anyone know of a macro to do this?  If not, can anyone here develop and
share one?  (This is beyond my poor Excel macro writing ability.)

Thanks! And Happy Holidays to all herein!

Vince Heiker
Flower Mound, Texas
--