Working with Excel (tools, indicators, conversion ...) - page 2

To add comments, please log in or register
david mackay
2837
david mackay  

Excel

I am not quite clear as to what this is.... LOL

I havn't used excel very often so I am unfamiliar...

Would this be a spreadsheet add in that provides all of those indicators.... to be used on data exported from Metatrader..?

for backtests..?

Does this operate on live data.....?

Thanks

dave

I think I will adopt this guy.........

Sergey Golubev
Moderator
106070
Sergey Golubev  
Blaiserboy:
I am not quite clear as to what this is.... LOL

I havn't used excel very often so I am unfamiliar...

Would this be a spreadsheet add in that provides all of those indicators.... to be used on data exported from Metatrader..?

for backtests..?

Does this operate on live data.....?

Thanks

dave

I think I will adopt this guy.........

Some people are using Excel for technical analysis. They are importing data from some sources to Excel format to analyse. They may explain you better because I am not using it.

Ahmed Soliman
19537
Ahmed Soliman  

Great!

newdigital,

It's a very useful program.

Thanks

david mackay
2837
david mackay  

Installation

I did download the prg and made a directory, started excel and added it to the appropriate part of the spreadsheet.....

and then I looked at the sample....... the working part disappeared.....

so I installed it improperly....... and when I attempted to recover it..... no luck...

Could I ask your assistance in getting it installed properly.....

Which directory does it go into..... and then the procedure to get it into excel so that it is available after I close excel and then re open...

Thanks for your assistance

dave

Sergey Golubev
Moderator
106070
Sergey Golubev  

Just unpack it to somewhere in your computer.

Open Excel, select from menu: 'Service', then 'Add-In'.

Then

to insert the file ta-lib.xll to the list which was opened

(because you press 'Add-In')

choose the file's location by pressing 'Browse',

then find this file (ta-lib.xll).

Make sure that 'ta-lib' was added in.

Then you may close everything if you want.

In the file example.xls

you will see the examples of indicators (examples only).

And in the file func_list.txt

you may see the list of the functions available

(to work with this indicators).

So, just open your Excel (with your data) once again,

press Shift-F3,

and you will see the master of function's menu,

select indicator and so on.

david mackay
2837
david mackay  

data....

I think I have the thing set up.......

and now I need some guidance in getting some Eod data, probably from yahoo...

That would probably be simpler than attempting to import from a charting program

Can you enlighten me as to how to use whatever feature to import from Yahoo....

thank you for your help

dave

Pyramid
48
Pyramid  

I may be wrong but dont think you can import from yahoo direct.

much better to use history center first to create CSV file which you can input to spreadsheet and then setup DDElink with MT4 for the future.

jeddah_man
6
jeddah_man  

Dear newdigital,

Thanks for you, how i can add more indicators! i need SATL,RSTL & DPO,

Can you help me plz

Sergey Golubev
Moderator
106070
Sergey Golubev  
jeddah_man:
Dear newdigital,

Thanks for you, how i can add more indicators! i need SATL,RSTL & DPO,

Can you help me plz

Sorry I am not using this Excel.

I do not know.

mj10
104
mj10  

Working with Excel (tools, indicators, conversion ...)

hi does any one knows how to convert day data of a stock into week and month in excel if someone can help me it would be very great full to him.

To add comments, please log in or register