Sansarva
where do you get these things?
The lkely problem cound be that the data table, from nest is as below
trading symbol, time, open, high,low, volume,
expontial average / expontetial average 2,
in rtnow. xlm or in Nest trader
then only can the answer be provided.pls look at the screen shot. pls arrange your columns in NOW/Nest Trader and NowRT.xlm as shown.
http://imgur.com/8y2R0
regards
sr
Josh sir,
I reararranged the data table from now, The problem could be after i back fill i checked the data in backfill.csv file in c drive, the colums as as follows,
NIFTY12MAYFUT,30-04-2012 09:15:00,30-04-2012 09:15:00,5229,5244.9,5226.15,5241.55,147100
NIFTY12MAYFUT,30-04-2012 09:16:00,30-04-2012 09:16:00,5241,5244,5241,5242.9,82000
NIFTY12MAYFUT,30-04-2012 09:17:00,30-04-2012 09:17:00,5242.9,5244,5242,5243.6,65700
NIFTY12MAYFUT,30-04-2012 09:18:00,30-04-2012 09:18:00,5243.65,5257.5,5243.15,5257,261700
NIFTY12MAYFUT,30-04-2012 09:19:00,30-04-2012 09:19:00,5258.8,5260,5253.8,5259.5,203000
The second and the third column are identical and the spiliting of te data into date and time has not occurred, also the date is in dd-mm-yyyy format while te file nest format has the line
$FORMAT Ticker, Date_MDY, Time, Open, High, Low, Close, Volume
$SKIPLINES 0
the date format required is MDY
my macro in backfill xlms is
If MsgBox("Do you want to split Date_Time into separate columns", vbYesNo) = vbYes Then
Application.DisplayAlerts = False
Columns("C:C").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Columns("B:B").Select
Range("B1").Activate
Selection.Copy
Columns("C:C").Select
Range("C1").Activate
ActiveSheet.Paste
Columns("B:B").Select
Range("B1").Activate
Application.CutCopyMode = False
Selection.NumberFormat = "m/d/yyyy"
Columns("C:C").Select
Range("C1").Activate
Selection.NumberFormat = "[$-F400]h:mm:ss AM/PM"
End If
the problem is that the spliting of time and date is not happening, kindly find where i did wrong
warm Regards