Sedang Disiapkan


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.

I'm looking for an Excel VBA expert with statistical/ stock market experience.
Sorry but if your resume dosn't show this I'm afraid I can't hire you.
Please don't bid if you do not have indepth experience of VBA and time series analysis..

Update to Clarify.

I have been asked to expand on what I need/expect.

I take end of day prices (via JSON) from our web database and displays them in Excel.
It is mostly commodity & currency prices. I want to add some 'forcasting' or prediction analysis.

I realize is not good to predict based on one time series. At best we are only showing simple probability on patterns.
This stage is to set the basis for expanding this project to stage 2 & 3 below.

Stage 1 here is easy enough but charts/reports must be dynamic, let the user select which studies to display (Confidence interval, Excel Forcast STD Deviation, Moving Averages etc). If moving average periods change they must update in real time. We must allow user to refresh and change datasource series, and run the prediction studies on any date in the chart so we can see the accuracy of the predicton ( this can be a second chart if needed).

We will want to see a table/chart plot of prediction % accuracy over time.
I'd like you to tell me what you can offer to improve the project.... more analysis techniques, charts. The VB is simple enought. It is the analysis I am interested in.

Stage 2:
It could get interesting is if we let the user use a sheet containing multiple time series (we have a standard format/layout) and select one primary series and check the other series in the sheet to see if individually or collectively actas signals/influences for the primary series,

It would obviously depend on the series the user selects but perhaps change in the prime series could be more accurately predicted by change in the other series - or not. A report/chart showing influence of each series would be good.

Stage 3:

It would be slow but perhaps it could be expanded to database searches for series that appear to influency the prime series. This would involve searching through 10000's of datbase series probably using python.

This project is for stage 1 only.

I need the developer to be able and willing to do stage 2.


I have upodated the project description to add what we discussed and explain where I want to go with it.

You can of course withdraw/change your bid if you feel it changes the original projects scope.

Kemahiran: Excel, Analisis Statistik, Visual Basic

Lihat lagi: vba excel time drawing mode, neural network excel confidence interval, wilson confidence interval excel, interval data real time data excel, time series forecasting spss excel sas, vba call time tracker excel, addition de time sous excel vba, factor analysis vba excel, vba excel time, create time simulator vba excel, vba excel form time tracking timesheet lan, vba excel show sheet report time, display running time macro excel vba, vba excel time optimize, excel addins installed analysis vba, discriminant analysis vba excel, vba excel column label, vba excel action opening workbook, cut paste vba excel, time management excel spreadsheet, can real time quotes excel tradestation

Tentang Majikan:
( 176 ulasan ) Feltwell, United Kingdom

ID Projek: #14080173

Dianugerahkan kepada:


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' Lagi

$120 USD dalam 3 hari
(0 Ulasan)

24 pekerja bebas membida secara purata $190 untuk pekerjaan ini

$155 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$444 USD dalam 3 hari
(49 Ulasan)

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 Lagi

$200 USD dalam 6 hari
(12 Ulasan)

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 Lagi

$200 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$368 USD dalam 7 hari
(20 Ulasan)
$150 USD dalam 3 hari
(32 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(54 Ulasan)

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 dalam 3 hari
(11 Ulasan)

- 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 Lagi

$200 USD dalam 4 hari
(39 Ulasan)

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 [login to view URL] Lagi

$200 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(39 Ulasan)

All tasks will be automated by python and VBA scripts to finish in timely manner rather than manual.

$155 USD dalam 3 hari
(0 Ulasan)

Having 6 years of experience in stock market, Currently working with A developer by profession. You can check our portfolio here. Looking forward for your message. [login to view URL] Lagi

$277 USD dalam 25 hari
(7 Ulasan)

A proposal has not yet been provided

$155 USD dalam 3 hari
(0 Ulasan)

Hello There, Here are some examples of my work. Project Report Automation - [login to view URL] Log Report Automation - [login to view URL] Lagi

$180 USD dalam 7 hari
(14 Ulasan)

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 Lagi

$170 USD dalam 6 hari
(37 Ulasan)
$49 USD dalam 3 hari
(8 Ulasan)

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 Lagi

$180 USD dalam 3 hari
(216 Ulasan)

Hello Sir, I believe I'm suitable for the job after reading your job request. As I can actually follow up the instructions that you provide smoothly and can add nice technical feedback about what's the cons and Lagi

$222 USD dalam 5 hari
(0 Ulasan)

Hi, My business is an established Info accessibility member of staff. This assists work. I'm able to give you 100% full satisfaction right up until undertaking finish. I am capable to provide work report daily/weekly Lagi

$155 USD dalam 3 hari
(0 Ulasan)