Excel daily Report on JSE Market data, Data Analysis automatic report

I need an excel report that generates the following;

1) downloads via excel or CSV file from standard bank online share trading all indexes and shares (or at least JSE top 40 shares & Indexes). Downlaods the Dow Jones Industrial Index from the site too every day.

2) Then if you go onto the standard bank online share trading site, login and you choose tools from the menu system, Interactive charts. Then you set the following parameters: Indicator 1 = MACD, Indicator 2 = Stochastic, type of chart, choose Candle, moving average settigns need to be on 12 and 26 day.

then choose to chat the Dow Jones Industrial (DJ-IND ticker) and compare the previous parameters over a 1 & 3 year to the JSE Index (e.g Satric Industrial - STX-IND) that has outperformed the DJ-IND over the past1-3 years

3) Then compare all the JSE Stocks (or top 40) that have outperformed that Index over 1, 3, 5 year and then all time period over the following time frame choices, Monthly, then Weekly, then Daily. Then flag or highlight on daily basis all those stocks that have done that.

4) then finally highlight all those stocks where the MACD and Stochastic indicators cross over at the same time either up or down - So if the cross over with MACD and Stochastic is up, then indicate an up for daily, weekly and Monthly or indicate whether there is a down cross over. Now the MACD consists of 2 indicators. You need to show where the black crosses over on the blue line indicator on the standard bank onlineshare trading (either up or down). then the same for the stochastic indicator but there where the red line crosses over the blue line (either up or down).

So the final output on the spreadsheet should show me:

1) those stocks that are going down (via the trend which is the MACD and then the stochastic gives you an indication of the timing of the share price movement) or up both from a trend and then timing viewpoint.

This probably by does need further clarification but just contact me and I can explain.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Veja mais: jse market data, daily jse analysis, jse daily market analysis, viewpoint bank, ticker line, red black data, online share market, on line market system, online market analysis, online chart tools, market analysis online, interactive data entry, industrial bank, excel for data analysis, dow jones, data analysis with excel, data analysis for excel, online dj, dj online, data analysis online, be a dj online, show me data entry, online market system, market over, go to market

Acerca do Empregador:
( 0 comentários ) Westbrook, South Africa

ID do Projeto: #5088737

Concedido a:


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

R1473 ZAR em 0 dias
(262 Comentários)

9 freelancers are bidding on average R3218 for this job


Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] Mais

R1804 ZAR in 5 dias
(32 Comentários)

I have extracted share prices from Yahoo & Google sites and created live graphs. As regards standardonline, will you be able to provide the price data.

R1888 ZAR in 10 dias
(27 Comentários)

Your project is really interesting Thing is that it's a little complicated as an xls file It's possible to do it as an web based and it can be much simpler, to gather data from another website. My proposal it's no Mais

R16666 ZAR in 30 dias
(1 Comentário)

A proposal has not yet been provided

R1088 ZAR in 2 dias
(0 Comentários)

if u describe the procedure, i will work very accurately. sure.......... because i am ready to work hardly.

R1088 ZAR in 3 dias
(0 Comentários)

Expert in Advanced Excel, has been a consultant and faculty to big corporate clients. Expert hand over Excel VBA as well..

R1088 ZAR in 3 dias
(0 Comentários)

A proposal has not yet been provided

R1088 ZAR in 3 dias
(0 Comentários)

I do my work with honisty. i need a work so please give this work to me. my skype ID is azharuddin.ansari83. so sir/miss give me this work. i make a new account on [url removed, login to view] i done this work in time limit. i have 1 Mais

R2777 ZAR in 2 dias
(0 Comentários)