IFTA: Which programming language best suits this task? (Database)?

IFTA: Which programming language best suits this task? (Database)?

Question by Andrew: Which programming language best suits this task? (Database)?
I need to create a script for data organization and visualization purposes associated with the financial markets (stocks, bonds, forex, etc). In the future I hope to do some P2P social media user-interface design and iPhone app ideas. I have very little or no programming experiences (html basics, programming TI-86 calculators, and simple flash 5 scripts), but taught myself finance with little trouble, so I am not afraid of complexity and learning curve. I just don't know where to start.

Below I have listed the specifics of the script desired (what functions I need it to have, etc). I need to know at the least which programming language to use and maybe a good site to find tutorials for creating the kinds of scripts that are relevant to my purposes. At the most, I would greatly appreciate some samples of code that can help me accomplish or learn how to do the following task .

I want to count and then visualize the number of times that the price moves over two exponential moving averages of 144 and 169 periods. I would like to have the option of being able to insert a filter: to only count the occurrences that stay above or below the exponential moving averages for X number of periods. I would also like to be able to easily visualize the data to show the occurrences that the price stayed over the exponential moving averages for X number of periods, Y number of periods, Z number of periods...(infinity)

thanks!
This program will not need to constantly recalculate. I'm basically just running an empircal test to determine the consistency of synchornious events inside of historical price information: If A price value is greater than moving average values (B) and (C) , will the price continue to rise, and if so, for how long?

I could imagine myself just downloading this information into excell and creating a VB script. What are the advantages of using PHP/mySQL in these types of environments? It seems that PHP/mySQL is web-based, which would help I'm guessing would help if the data set is very large and/or if the process must be on-going for a long period of time (e.x.: SETI) am I right?
I trade with MT4.


Best answer:

Answer by Warren
I'm not much of a finance guy, but for my serious projects I've always used C# developed in MS Visual Studio.

I don't know of any sites for tutorials, but after you get the basics of programming, make sure you understand your Object Oriented Principles. After that the sky is the limit for what you want to do.

Know better? Leave your own answer in the comments!

Question by Andrew: Which programming language best suits this task? (Database)?
I need to create a script for data organization and visualization purposes associated with the financial markets (stocks, bonds, forex, etc). In the future I hope to do some P2P social media user-interface design...

Question by Andrew: Which programming language best suits this task? (Database)?
I need to create a script for data organization and visualization purposes associated with the financial markets (stocks, bonds, forex, etc). In the future I hope to do some P2P social media user-interface design...


Categories : Forex


Tags: best, database, IFTA, language, programming, suits, task, this