I have the history for some stocks and shares. The history is in a worksheet sheet and there will be a column of dates in column A and columns of prices ( starting at row 8) .

I want this project to let me select a price column and create the study below in a new worksheet:

[url removed, login to view]

Yiou can store the source sheet & column in cells in the new sheet.

We need the data & chart in a new worksheet with a refresh button to recalculate the data & forecast.

The forecase data must be present in the sheet under the chart.

Clicking on the chart plot area should calculate a forward curve on the date along the X axis so we can see what the forecast was on that date and compare it with the actual data. We need to be able to draw the 3 forecasts on the clicked date if they are displayed in tte forecast.

I'd like to add some analysis to the chart like

Confidence interval, [url removed, login to view]

Regression : [url removed, login to view]

Excel Forcast : [url removed, login to view]

and STD Deviation plus 2 user defined moving averages


These can be toggled & adjusted by checkboxes on a user form where necessary.

Add 2 buttons on the sheet to let us select a different source series...

VBA only - if formulas used they must be added by VBA

Prices can have #N/A values so they must be allowed for in the calculations

Obviously changing the data source (column) can change the range of data used.

It has to look smart and be designed to add more analytics or perhaps plot a second column in the chart.

Knowlewdge of the subject is important..... Impress me :)

Let me know what you can do to improve the concept...

More work available to the successful bidder if all goes well.

Taidot: Excel, Tilastoanalyysi, Visual Basic

Näytä lisää: wilson confidence interval excel, vba excel time, vba excel time optimize, vba excel column label, cut paste vba excel, time management excel spreadsheet

About the Employer:
( 176 reviews ) Feltwell, United Kingdom

Projektin tunnus: #14080173

Myönnetty käyttäjälle:


Hello, you have a super cool project. I'm a Vba expert which was the result of stock/option trading. I have expert skills in technical and economic analysis for trend forecasting and love the ideas on the features you' Lisää

120 $ USD 3 päivässä
(0 arvostelua)

25 freelanceria on tarjonnut keskimäärin 189 $ tähän työhön


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

180 $ USD 3 päivässä
(187 arvostelua)

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Lisää

368 $ USD 7 päivässä
(20 arvostelua)

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL/VBA Business Information System, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exchange Lisää

444 $ USD 3 päivässä
(48 arvostelua)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Lisää

155 $ USD 3 päivässä
(56 arvostelua)

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Lisää

250 $ USD 3 päivässä
(50 arvostelua)

hi, Lately I prepared a similar project, the module reads selected historical tickers information from Yahoo Finance, shows statistic results based on algorithms, creating candle charts and show the best results by ord Lisää

250 $ USD 3 päivässä
(32 arvostelua)

- Have good command over Excel VBA Scripting. - Knowledge on Stocks, Futures, Options. - Can develop the Actual Vs Forecast curves for the stocks, regression, confidence indicators and standard Deviation. - Have don Lisää

200 $ USD 4 päivässä
(39 arvostelua)
150 $ USD 3 päivässä
(21 arvostelua)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Lisää

170 $ USD 6 päivässä
(30 arvostelua)

Hello There, Here are some examples of my work. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.dropbox.com/s/ Lisää

180 $ USD 7 päivässä
(13 arvostelua)

Dear Sir Good Day with many greetings to I'm professional in Excel & VBA if you are interesting to work together hire me regards

35 $ USD 3 päivässä
(11 arvostelua)

I am a statistician with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank yo Lisää

155 $ USD 3 päivässä
(5 arvostelua)

Dear, I'm very interested with your project thank to your detail description. Can not wait to make it work as your expectation . About me , I'm a data analyst with experience of VBA on Ms Excel. Now I'm focusing on pr Lisää

200 $ USD 6 päivässä
(11 arvostelua)
49 $ USD 3 päivässä
(7 arvostelua)

Having 6 years of experience in stock market, Currently working with hybridsolutions.com. A developer by profession. You can check our portfolio here. Looking forward for your message. www.hybrid-solutions.com/plugin Lisää

277 $ USD 25 päivässä
(7 arvostelua)

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Software Professional. I am new to this platform and looking for more and more opportunities. Below are Lisää

200 $ USD 3 päivässä
(0 arvostelua)
155 $ USD 3 päivässä
(0 arvostelua)

i am post doc research my research area is about computer vision and robotics, I am expert on statistical analysis, i have many academic papers about it. you can check my google scholar page here is https://scholar.go Lisää

200 $ USD 3 päivässä
(0 arvostelua)

A proposal has not yet been provided

155 $ USD 3 päivässä
(0 arvostelua)

I had done MS in Engineering. Also I had 9+ years of experience in the field of Excel VBA programming, Machine learning, regression analysis and statistical analysis. I can do this task for you

155 $ USD 3 päivässä
(0 arvostelua)