Fermé

Excel dynamic stock chart

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.

Compétences : Excel, Visual Basic, Traitement de Données, Visual Basic pour les apps , Saisie de Données

en voir plus : how to combine two stock charts in excel, how to build a stock chart in excel, excel stock chart secondary axis, excel multiple stock chart, excel stock chart template download, excel overlay two stock charts, stock comparison chart excel, excel dynamic chart, dynamic stock chart, dynamic stock chart website, dynamic stock graph excel, excel dynamic stock chart dde, create dynamic header chart excel, pie chart excel dynamic, excel dynamic data exchange stock prices excel, excel dynamic charting stock, visual basic excel dynamic chart axis move, excel dynamic stock chart, excel dynamic chart example, dynamic stock charts excel

Concernant l'employeur :
( 0 commentaires ) peschiera borromeo, Italy

Nº du projet : #20776874

10 freelance font une offre moyenne de €28 pour ce travail

schoudhary1553

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(339 Commentaires)
8.0
daniyal3214

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(51 Commentaires)
5.4
xinglong717

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(11 Commentaires)
4.2
maguirrer

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(24 Commentaires)
3.9
ielucerotrad1

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(11 Commentaires)
3.7
letsexcel

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(4 Commentaires)
3.5
samobot

"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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(1 Évaluation)
0.2
AndreiPPB

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
TecXora

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(0 Commentaires)
0.0
FinExel

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0