Hi All

I wrote and Cutome code as below , that works well in development environment,

During Preview it gives me perfect Output,

but after the deployement it gives me...

Sir,

I am not able to calculate the

TR14,+DM14,-DM14,+DI14,-DI14,DI14Diff,DI14Sum,DX,ADX

From #ADX_Data

The Calculation is done as per attached excel sheet.

Sorry sir,i forgot to paste the last line

i.e. Group by

----Below is corrected code-----------------

select Symbol_Code,

Transaction_date, sum(TR) as TR14,

sum(Positive_DM) AS PDM14,

sum(Negative_DM) as NDM14,

case when (sum(TR)>0) then(100*(sum(Positive_DM)/(sum(TR))))...

I have commented the line which is giving the error

select Symbol_Code,

Transaction_date, sum(TR) as TR14,

sum(Positive_DM) AS PDM14,

sum(Negative_DM) as NDM14,

case when (sum(TR)>0) then(100*(sum(Positive_DM)/(sum(TR))))

when (sum(TR)=0) then 0 end

as...

Sorry Forget the give u function

Create the below function which will give you highest value out of three values

-----------------------------------------------

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

create function [dbo].[Greatest](@val1 decimal(18,2), @val2 decimal(18,2),@val3 decimal(18,2))

returns...

If you got the error

just comment the line as shown in below query.

Select Symbol_Code,

Transaction_date, sum(TR) as TR14,

sum(Positive_DM) AS PDM14,

sum(Negative_DM) as NDM14,

case when (sum(TR)>0) then(100*(sum(Positive_DM)/(sum(TR))))

when (sum(TR)=0)...

Yes Sir

It is ADX - Average Directional Index (ADX).

Yes it has error. now i have resolved the error.

Just run the insert query to insert data into table.

then...

i am expecting an output to be as show in excel

High LowClose TR+DM1 -DM1 TR14+DM14 -DM14 +DI14 -DI14 DI14Diff ...

Sample data to test

----create the table NSE_Stock_Data run below query to get the data

------------------------------------------------------------------

--drop table NSE_Stock_Data

create table NSE_Stock_Data

([Transaction_Id] [int] NULL,

[Transaction_date] [datetime] NULL,

[Symbol_Code] [varchar](50) COLLATE...

I just trying to calculate ADX index as per attached sheet , right

the Adx is calcuated based on 27 days high , low and close data of company,

the...

Ok ,

Thanks for your help.

Wasted your valuable time.

Sorry answer is NO

as on Holidays data is not available.

Yes

Well the condition should not on 13 rows before , it should be on thirteenths days before

as below

select ID,

Symbol_Code,...

In the if condition i check whether am i getting the exact thirteen previous days(13 row) if count is less than 13 then i again subtracting the missing rows from...