Well it depends upon the Bank holidays (Not fixed ) and every Saturday and Sunday

I tried this way

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

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER proc [dbo].[ROC_NEW]

@Symbol_Code varchar(50)

as

Declare

@Cnt int,

@crt...

Thanks Chrism for Solution.

I have one doubt,

For the ROC Calculation , i have to select the closing price of thirteen days before, how can select the thirteen days...

I want to calculate the ROC as per formula

The Rate-of-Change (ROC) indicator, which is also referred to as simply Momentum, is a pure momentum oscillator that measures the percent change...

I want to calulate the 12th days Rate of change

for each company. Please find the attached excel

Formula is as below

ROC = [(Close - Close 12 periods ago) /...

I want to calulate the 12th days Rate of change

for each company. Please find the attached excel

Formula is as below

ROC = [(Close - Close 12 periods ago) /...

Please find the attached excel sheet

Hi Everybody i trying to calculate the Rate of change of Stock

I have data like as below ,

i want to calculate the 12th day ROC on the Thirteenths...

Can Anybody know how to calculate the Rate of Change from EOD_Stock Data

i tried but stuck smoewhare

alter

proc Roc as

IF

OBJECT_ID(N'tempdb..#FinalROC', N'U') IS NOT...