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 freelance font une offre moyenne de €28 pour ce travail
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus
I can definitely help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated da Plus
Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Plus
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.
I can get the job done! I would fully comment the code and write it in a clear modify frienldy manner. Could add 'help' worksheet with instructions. About me: I'm an engineer with advanced working knowledge and exper Plus
Qualified Account and VBA Expert, please check my profile I personally have Stock Exchange investment experience , I have developed workbooks for my investments. This graphical presentations seems interesting. ===== Plus
"I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrie Plus
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.
Can you please provide your sample excel sheet, so that i can make it and show it you. if you are satisfy with it, then only pay money
We will create a candlestick chart based on OHLC data and in the bottom pane, a line chart will be created. Once you zoom or move above the candlestick chart, below pane will also act accordingly. Different color code Plus