Hi all,
The original location of NowBackfil.xls is in E:\ whilst the autogenerated NowBackfil.xls and MyCSV.xls are created in C:\.
Josh1
actually the date part sucks in backfilling. trying to backfill in the evening - tried twice but was struck in the middle. then reverted to my semi automatic backfilling which i do in 1 min.
so no question of backfilling headache with nowbackfill.xls
sr
Hi,
If it is possible, please
How to back fill from OHLC chart for toaday's data backfill,
This is the part in code where we are splitting date/time field.
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").Activa te
Selection.NumberFormat = "[$-F400]h:mm:ss AM/PM"
End If
You can try following things.
1.Comment out the red lines, control you date and time formats through Start-Control Panel-Regional and Language options-customize-date tab or time tab. Excel defaults to these formats.
2.Change the formats in above lines and try.
3.Open the NowBackfil.csv and see the date and time formats. Change the date format in Nest.format file to match it.
Please note that AmiBroker requires TIME time in HH:MM:SS or HH:MM or HHMM or HHMMSS format that means in 24 hour format only.
Please tell me which one is working well so that I can make changes in code.
In my case, I have kept interval of 1 Min. in NestPlus chart. I click on any scrip in market watch, Press Ctrl+P and Nestplus chart is generated. Click anywhere on the chart and Press Ctrl+D. Data table pops up. Click in the data table and Press Ctrl+A to select all or select whichever date range I want.(Data can be sorted by clicking on column headings). Then click on cell A1 in NowBackfill.xlsm Sheet1. If AmiBroker is open, save datbase. Click on Backfill. Takes less than 15 seconds for each scrip.
This is for FnO data. You can use DataDownloader made by Joydeep for cash scrip if you want to backfil bulk data. It can extract 10 days data from Google.
Newbie12345- We are not autogenerating any .xls files. NSE-NOW-RT2.1.xlsm and NOWBackfill.xlsm generate MyCSV.csv and NowBackfil.csv file respectively. Former are Excel files whiel the later are text files meant to be imported by AmiBroker.