Beginner help changing VBA for point and figure charting...

I have come across an excel spread sheet that generates a point and figure chart (used for trading) based on high and low data. I want to change this so it is calculated from just closing values. I also would like to add data column for volume where the volume number is added to the top or bottom of each column based on whether it is a up column (x) or down column (O). Lastly I would like to remove the part of the code that deals with retrieving data from yahoo as I don't have any use for this feature.

I am an experienced and profitable day trader that has been hand charting point and figure charts for a while. If anyone can help and is interested in trading I would be willing to teach them some of the basics of using point and figure charts. This is an invaluable tool that has fallen out of favor with the modern trader. I have also included a sample of a hand drawn chart.

Please let me know if I can provide any more information.