Attached is a gif of an Excel chart that uses unique market volume to try and predict short term market direction. As the chart indicates the market should be down for a significant part of the day for Monday 3/12.
I use Excel rather than Tradestation or Metastock because it is more flexible in combining price & volume from multiple stocks / industry groups. However it is a labor intensive process to load data into individual worksheets.
Can anyone please recommend a program where one can easily combine price & volume from multiple stocks / industry groups?
Thanks,
Pete
