I have an excel file file with some Visual Basic programming that needs a little addition.
The arrows and bands displayed by the program need to show values on top of the objects.
I am attaching the excel file with current programs (Macros). When you run the macro "Setshape" on worksheet named "ADR", it creates a white arrow and a blue band for each ticker.
The addition I need is to display start and end point values for these objects.
See attachment "Before" to see current setup. Then see attachment "After" to see what I want to do. Note- display is not limited to just first five objects I only did it by hand to show you how the project need to be done. You have to program it all the way for each 20plus objects.
So this is what you need to do: grab "arrow" values from the table to the right on "[url removed, login to view]" file and font type "Ariel" size 10 display them above arrow. "Today" price font is bold.
Same way, you display TE Lo and TE Hi values within the blue band. Font I used is Arial, size 8, color white.
Thank you for your cooperation.
12 freelancers are bidding on average $122 for this job
Hello, I am specialist in MS Excel, VBA and scripts. Working on shapes and numbers like this is my job and my hobby. Hiring me is the right decision. :) You will be satisfied with the results.