オープン

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.

スキル: エクセル, ビジュアルベーシック, 情報処理, アプリ用ビジュアルベーシック, データ入力

さらに表示: 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

採用者について:
( 0件のレビュー ) peschiera borromeo, Italy

プロジェクトID: #20776874

9人のフリーランサーが、このジョブに平均€28で入札しています

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 もっと

€35 EUR 1日以内
(339件のレビュー)
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 もっと

€50 EUR 1日以内
(50件のレビュー)
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 もっと

€19 EUR 7日以内
(11件のレビュー)
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.

€22 EUR 1日以内
(24件のレビュー)
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 もっと

€30 EUR 2日以内
(11件のレビュー)
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. ===== もっと

€30 EUR 7日以内
(4件のレビュー)
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 もっと

€19 EUR 7日以内
(レビュー1件)
0.3
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.

€19 EUR 7日以内
(0件のレビュー)
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

€30 EUR 7日以内
(0件のレビュー)
0.0