I gang

Excel work based in financial markets

Hi there,

I need a Freelancer to start with an existant Excel spreadsheet and change it so it can make more complex calculations searching data in an external CSV sheet.

I'm not an Expert in Excel or programming, so i need someone that knows very well to work with calculations in Excel or any other calculations program or software, or even a programer that can program the same situation using the CSV data and make complex calculations.

After contact by the freelancer, i can explain a little better the work, we can agree the price at that time.

So i hope this can be a win/win situation for you and me, so we can do more works in the future, this will be the first work for now, and if everything runs well i will get you much more works.

Below is a little descritpion of the work to do.

I'm sending you the Excel sheet and CSV file and a JPG file i have created and from what i want you start and understand, it's not a complicated spreadsheet, but it must be able to do several calculations so it can give diferent results and colors in each cell automatically.

The [url removed, login to view] it's an example of what it is a financial bar, each vertical black bar, as a small left trace that it's called the "OPEN" of the bar, at the right of the bar is also a small trace that it's called the "CLOSE" of the bar, and the "HIGH" of the bar is the top of the bar and the "LOW" of the bar is the bottom

of the bar.

So the rule is everyday that the bar of the 10:30 closes it opens a new one and that new one will open with a quotation (example anterior bar close at 1403,75 and open the new bar at 1403,50) this new bar will generate a Buy or a Sell order in the market following this next calculations:

Number one - At the bar of 10:30 in the line 7 at the CSV file if the CLOSE is below of the OPEN is a SELL order at the next open bar at line 8 in CSV file.

Number two - At the bar of 10:30 in the line 7 at the CSV file if the CLOSE is above of the OPEN is a BUY order at the next open bar at line 8 in CSV file.

Then you apply the diferent Take Profits (20 points) and Stop Losses (12 points)for example in each column in each Exit systems and cells, and calculate the maximum points HIGH and the minimum points LOW in each cell with diferent colors like it is in the example spreadsheet.

The data in the CSV file is the following:

Date of the bar,

Hour of the close bar,

OPEN of the bar,

HIGH of the bar,

LOW of the bar,

CLOSE of the bar.

The spreadsheet is for testing systems or strategies in the Financial markets like Dow Jones, Nasdaq,

S&P 500 and so on, Forex, etc,,,,.

I have a thid party software that exports the data in CSV of real time quotations (prices) from the markets and from it i want the Excel or any other program makes the calculations so it can know if it's a sell or buy, calculates the take-profits and stop-losses and put in the spreadsheet the High of the financial bar, the Low of the bar and the Close of the bar using several Exits like described in the Excel sheet.

I know this may seems a little complicated at the begining for persons outside of the financial markets, but i will explain you everything thru my MSN or using my skype calling to your mobile

phone or fixed line so we can take all doubts for the work.

Please if you can improve the presentation of the spreadsheet, ideas will be welcome, inclusive of graphic lines, drawings updating day by day how is going the trading in the markets in a diferent spreadsheet or program.

I will explain you all this better by MSN or Skype, hope to hear from you soon,

Best regards,

Fernando

Færdigheder: C programmering, Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: works need excel, work graphic freelancer, work close, work software freelancer, need work freelancer, we excel, trace freelancer order, top work, top searching, best work freelancer, systems freelancer, start using freelancer, software testing start, sell thru, sell software freelancer, sell sheet freelancer, sell drawings, searching program, searching programming, quotation freelancer, price freelancer mobile, order freelancer, line presentation, number one freelancer, me excel

Om arbejdsgiveren:
( 0 bedømmelser ) Lisbon, Portugal

Projekt-ID: #306766

Tildelt til:

agusgfl

Dear Fernando, As a trader, i am used to work with this kind of data, using Excel, too. Barchart and Candlesticks chart are familiar to me, as well as chart-patterns, eg. doji, dark-cloud, etc. By the way, i hav Mere

$185 USD in 3 dage
(3 bedømmelser)
2.7

31 freelancere byder i gennemsnit $122 for dette job

MAnkita

Hello,Please refer your PMB.Thank you.

$200 USD in 5 dage
(143 bedømmelser)
6.8
LK1811

Pls check PM

$225 USD in 8 dage
(73 bedømmelser)
6.6
spawar

Hi, I've a good experience in a excel, and also I'm doing the programming work also, so I'll check the feasibility of this work, its complicated to understand, but I'll do it, and Interested to work with you long te Mere

$150 USD in 7 dage
(50 bedømmelser)
5.9
imranamin

EXCEL - VBA EXPERT . LETS DO IT

$200 USD in 15 dage
(37 bedømmelser)
5.8
asyraf1156

Hi.. I can do this work for you.. Please see Pm.. thanks

$150 USD in 3 dage
(57 bedømmelser)
5.6
crajeshbe

Forex Programmer Bid. Extensively worked Rate providers such as Reuters, Aspen Graphics, Yahoo Finance and so on.Please have a look at PM. Regards C.Rajesh B.E

$200 USD in 3 dage
(19 bedømmelser)
4.8
cosmoinfosys

Dear Sir, Please check PMB for details. Regards.

$199 USD in 7 dage
(3 bedømmelser)
3.1
radus28

This can be done in excel. Please describe me more about the calculations needed.

$100 USD in 10 dage
(1 bedømmelse)
2.9
excelinnovation

Hi, based in UK. Please see PM. Regards

$120 USD in 7 dage
(7 bedømmelser)
2.7
ma7oda

it is easy and i'm ready to do it for you sir, please check PM

$30 USD in 2 dage
(4 bedømmelser)
2.3
sontosh

Please PM more details. Thanks.

$50 USD in 3 dage
(1 bedømmelse)
1.8
stevegoodwin

Please see PMB for details.

$30 USD på 1 dag
(1 bedømmelse)
1.4
enfi

hello, i am intersted in your project,plz check PM

$100 USD på 1 dag
(4 bedømmelser)
1.0
erhupadhyay

I have readymade sollution which is developed by mine for some hotels in rajasthan it will do create every kind of reports as per your custmization. As I m working as a IT Manager in a very reputated 5* Deluxe hotel Mere

$150 USD in 5 dage
(0 bedømmelser)
0.0
calcul8ors

Hi Based in Australia, with extensive experience in csv manipulation and excel programming, and solid knowledge of Financial Markets. Looking forward to working with you.

$250 USD in 10 dage
(0 bedømmelser)
0.0
salmansyed

hi,i am a stock broker, i can do this work easily.

$150 USD in 5 dage
(0 bedømmelser)
0.0
suraj107b

We are an Indian Company and can start immediately on this work. Please provide us with the details.

$200 USD in 2 dage
(0 bedømmelser)
0.0
bbarui

Dear Sir, I am an individual service provider with more than 5 years of experience in excel macro programming. I would like to do the job for you. As I am new my quotation is very low. I expect release of payment only Mere

$30 USD in 5 dage
(0 bedømmelser)
0.0
competech

I've done this kind of project before many times , which means I'm kind of expert in excel and programming. Please read PM first, thanks.

$100 USD in 3 dage
(0 bedømmelser)
4.3
Setar22

Hello I am interested (EXCEL-VB Expert)

$150 USD in 4 dage
(0 bedømmelser)
0.0