Hi, I need an excel feature, written through VBA code. What I need is this: I have some input data on the sheet (Open Price, High Price, Low Price and Close Price). So, 4 columns.
In column 5 there is a different variable, let's say VARIABLE X. Column number 6 and 7 have fixed values, and they are the maximum allowed value for varialbe X and minimum allowed value (in the attached image they are 0 and 100). I want to be able to:
1. display the stock chart and below a LINE CHART with variable X. There will be a lot of data, so I would like it to be zoomed in, with a bar to move dinamically the two chart. When I move on the left the stock chart I would like VARIABLE X LINE CHART moving, too.
2. I have a 8th column. The column is empty, but sometimes there is a "yes" value. If there is a "yes" value I want that single stock chart bar to be coloured in a different way than other candles. (in the attached file it is the dark green candle).
I want to have the VBA code explained in order to be able to edit it.
10 freelancere byder i gennemsnit €28 på dette job
Hello, I can help you with the project, please send me a message with the excel file as an example with data, and I will start working on it immediately.
Hello. I'm very interested your project. I read your description carefully. I'm very talented Vb.net developer. if you assign to me this project, you can get a cool result. please contact me. thanks. best regards.