Programming help Extarck csv file from Nest

[test123]

Hi

Extarck csv file from Nest for all script listed in marlet watch

I need a program has to be exe Or macro or any code any language that is able to extarck csv file from nest pulse.

all it has to do is auto select scrip say 15 scrip then ctrl+D give save table and it has to save that data table with name as it is ..

csv format the better .

just note :--
sometime data table can be ***** and give failed to write file error.


Is there any angel in out community that can do it

reason i ask is currently i manually click data and save file and i beleive with macro programming this can be automated only if i knew how to code

data in file csv should look like

NIFTY15MAYFUT,20-05-2015 15:21:00,8423.0500,8425.8500,8423.0500,8424.0000,58000
NIFTY15MAYFUT,20-05-2015 15:20:00,8427.0500,8428.0000,8423.0500,8423.0500,54800
NIFTY15MAYFUT,20-05-2015 15:19:00,8424.9500,8427.4000,8424.7000,8427.0500,26525
NIFTY15MAYFUT,20-05-2015 15:18:00,8425.0500,8426.5000,8424.6500,8424.7500,19200
NIFTY15MAYFUT,20-05-2015 15:17:00,8423.9500,8425.5500,8423.2500,8425.0000,17650
NIFTY15MAYFUT,20-05-2015 15:16:00,8427.0000,8427.0000,8423.5000,8423.6500,38200
NIFTY15MAYFUT,20-05-2015 15:15:00,8424.1000,8427.0000,8424.0000,8427.0000,31900
NIFTY15MAYFUT,20-05-2015 15:14:00,8426.0000,8426.4000,8423.5500,8424.0000,26175
NIFTY15MAYFUT,20-05-2015 15:13:00,8422.3000,8426.1500,8422.0000,8426.0000,36600

 

[niftybreakout]

Thanks for such an initiative. I am also looking for such an utility that will give me data tables for various scrips of the market watch on press of a button.

 

[test123]

allright one temporary solution can ne you record keystrokes and mouse clicks using macro program and repeat macro. i know better solution canbe made tho

@niftybreakout
for now use Auto Macro Recorder .. untill someone comes with better idea ^^

 

[josh1]

allright one temporary solution can ne you record keystrokes and mouse clicks using macro program and repeat macro. i know better solution canbe made tho

@niftybreakout
for now use Auto Macro Recorder .. untill someone comes with better idea ^^

My applications are doing that for more than six months it is free

 

[test123]

ty josh1 i thought about it your app does it but unfortunately i was never able to run the application successfully.

any ways i made macro exe temp solution

Do not run this in market hours
As it;s clicks and stroke so sometime it might mess up

thats reason i said temp solution we still need permanent solution

https://drive.google.com/drive/fold...sxSjBheEZ5aU1JNmYzT042YURCblkzS3hxU0plNGZFams

pass to extarct is
test123

your screen resolution should be 1024x768
and you must be logged to nest run that and enjoy it will extract first 12 script.
nest should be first tab


**made it according to my need one can use macro recorder if u want to customized 1 time job record it and pain gone forever

 

[Raghuveer]

ty josh1 i thought about it your app does it but unfortunately i was never able to run the application successfully.

App works amazingly well. Post or pm me what problem you faced.

 

[Dax Devil]

App works amazingly well. Post or pm me what problem you faced.

It is the best. I downloaded it last week. Working beautifully. God bless Josh1.

 

[test123]

i decided to give a try to rtd again and this time it worked

i can see it back filled data for 22 days.
now question is how do i back fill data more then 22..

i have csv file from nest from last 1 year.

so any pointers or how do i convert data to rtd format .

Bwt rtd has source seelction if u do Back fill from wvap then it generates 1 min candle .

Rt folder has csv file it;s format is

NIFTY15JULFUT,20150717,025900,8629.4000,8632.8000,8628.5500,8631.0000,106175,

csv file that i have historical

Trading Symbol,Time,Open,High,Low,Close/Price,Volume
NIFTY15AUG8800CE,16-07-2015 03:00:00,97.4000,97.4000,97.4000,97.4000,0
NIFTY15AUG8800CE,16-07-2015 02:59:00,97.2500,97.7500,96.6500,97.4000,5650

so how do i ....

 

[Raghuveer]

i decided to give a try to rtd again and this time it worked

i can see it back filled data for 22 days.
now question is how do i back fill data more then 22..

i have csv file from nest from last 1 year.

so any pointers or how do i convert data to rtd format .

Bwt rtd has source seelction if u do Back fill from wvap then it generates 1 min candle .

Backfill for more than 22 days is not there in NEST/NOW.
"so any pointers or how do i convert data to rtd format .": Don't convert any NEST data. Create/edit *.format file and use it to import. For old csv from NEST you can use rtd2.format given in Josh1 app. See below for example.
or just use RM1min-OI.format as shown below.

Data from data table is preferred compared to VWAP data. VWAP data has different start/end time and candles will look different.

Copy pasting instructions I sent to someone else sometime back (may look too detailed for you):

You can use NF/BNF/Index data by RM: www.tinyurl.com/oneminutedata

Using Notepad copy paste and save below as "RM1min-NS.format"

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_YMD, Time, Open, High, Low, Close
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

Using Notepad copy paste and save below as "RM1min-OI.format".

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_YMD, Time, Open, High, Low, Close, Volume, OpenInt
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

Close Amibroker if open.
Copy these *.format files to folder "C:\Program Files (x86)\AmiBroker\Formats"
If you installed Amibroker in another location copy them to ...\Formats\ folder in that location.

Open blank notepad. File-Open. Above "Open" button select "All files (*.*)" from pull down menu.
Now navigate to "C:\Program Files (x86)\AmiBroker\Formats"
Select file "import.types"
Copy paste below two lines anywhere.

RM1min-OI format (*.*)|*.*|RM1min-OI.format
RM NS format (*.*)|*.*|RM1min-NS.format

Save file "import.types" and close notepad.

Now open AmiBroker.
From menu File-Import ASCII. "Open" window will come.
Here select "Files of type" "RM1min-OI format" if you are importing Futures data.
OR select "Files of type" "RM NS format" if you are importing Spot/index data.

Navigate to folder containing OLDEST data. Data must be imported oldest to newest for minimum import time. Otherwise it will take exponentially increased time to import.

Multi select (CTRL+A to select all files in folder) files to import. Do not select index and futures data at the same time. tinyurl data by RM has both index and futures data in same folder.

Click "Open". Now WAIT. For RM NF/BNF data generally completes in few minutes per folder. Even if it takes 30minutes or more (e.g. for stock futures data) just wait. It will complete import even if it takes 1 hour per folder. If you kill the process it might corrupt the whole data. Save.

Keep importing folder by folder. Save.
For Nifty50 data by RM see: https://tinyurl.com/RM-4shared-folders

 

[test123]

@Raghuveer loading speed is not issue .I have SSD . 700 mb of csv i.e entire NSE data loads in less then 15 sec :xD


it;s been 1 year i save csv file of every month for nifty....
csv file was collected using shift+d using nest pulse
so now i have csv file of nifty thats quite fat and large and every month i merge them.

more over there is histrocial database available from nest itself as EOD.
live 3 month 6 month and 1 year so if just those is added at behind one can easily view Daily chat in amibroker. rtd is fine does all auto work so limited to 22 days ?

alright i will redefine my query

below is file how do u merge that with backfill of rtd
Niftyfutures csv database .

https://www.mediafire.com/?srqh2u9f5h7m4ui

i think i got my answer i think will have to re modifty the columns that rt`d is using ..
and force rtd to use format Trading Symbol,Time,Open,High,Low,Close/Price,Volume only
uzzzz
i hate doing operation of code
anyways ty all for help
In end something is always better then nothing