Geek asks and answers

How to do technical analysis calculations in sql server?

How can I perform calculations of technical analysis indicators, such as the average directivity index, stochastic oscillators, etc. in a SQL SERVER database using T-SQL, as in excel? If possible, is it useful to make procudures how to make macros in excel. Thanks in advance.

+3
source share
3 answers

The procedural code is written in T-SQL in MS SQL Server. This is as good as Excel macros and perhaps a little more powerful, but they are unlikely to be as familiar to you as the good old Excel.

+2
source

, , . , T-SQL ( ..).

, T-SQL, , ( , , ):

http://www.sqlservercentral.com/articles/Moving+Average/69389/

, T-SQL . T-SQL.

+1

Writing technical analysis code in T-SQL is not a good idea. If you really want to execute it on the database server; then I would recommend writing your code in any .NET language and uploading the code to SQL Server. You can then call this code from T-SQL using the "Custom Functions". See Link.

I did similar things in Oracle for another purpose.

If possible, try checking if you can execute the code on the client side or on the web server, if applicable in your case.

0
source

More articles:


All Articles