indiTraders - Forum for the Active Indian Trader  

Go Back   indiTraders - Forum for the Active Indian Trader > Tools > Data

Data Share Data & Discuss Data Sources

DPonline
Reply
 
Bookmark and Share LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 27-11-2016, 06:44 PM
rsi rsi is offline
indiTraders VIP
 
Join Date: Mar 2009
Posts: 876
Thanks: 949
Thanked 3,693 Times in 809 Posts
rsi has a reputation beyond repute
rsi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond repute
Default How to do this?

Friends,

I need your help. Here is the problem

I have attached the txt format file containing delivery data for BSE stocks. This file is downloaded from BSE itself.

I can also download daily bhavcopy file from BSE. But that file does not contain delivery data.

Therefore, I want to add one more column to the daily bhavcopy file containing delivery data.

I have converted the txt file (containing delivery data) to csv file thinking that by doing so, I can easily copy the entire columns and paste it to bhavcopy file.

But the problem I am facing is that even after converting it to csv file, I am unable to copy paste the data as I am intending. For that matter, data does not get sorted in to columns at all. I am unable to copy and paste the data also.

How to solve this problem?

Your help is greatly appreciated.

Thanks in advance
R. S. Iyer
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to rsi For This Useful Post:
  #2 (permalink)  
Old 27-11-2016, 06:48 PM
rsi rsi is offline
indiTraders VIP
 
Join Date: Mar 2009
Posts: 876
Thanks: 949
Thanked 3,693 Times in 809 Posts
rsi has a reputation beyond repute
rsi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond repute
Default

As I am unable to attach file mentioned in the previous post, I am giving the link from where this file can be downloaded in zip format. File size exceeds forum limit and hence I am unable to attach the file

http://www.bseindia.com/markets/equi...dable=3&flag=0
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to rsi For This Useful Post:
  #3 (permalink)  
Old 27-11-2016, 07:01 PM
Sunshine's Avatar
Sunshine Sunshine is offline
indiTraders VIP
 
Join Date: Oct 2009
Posts: 2,536
Thanks: 6,217
Thanked 4,450 Times in 1,988 Posts
Sunshine has a reputation beyond repute
Sunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond repute
Default

@Rsi
Open the file with Excel . Then manipulate it .
If you cannot select the column - remove the heading and adjust it- then select it .
This is a layman's solution . Experts may tell you an easy solution
__________________
A man who moves a mountain begins by carrying away small stones - Confucius
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to Sunshine For This Useful Post:
  #4 (permalink)  
Old 27-11-2016, 07:33 PM
Sunshine's Avatar
Sunshine Sunshine is offline
indiTraders VIP
 
Join Date: Oct 2009
Posts: 2,536
Thanks: 6,217
Thanked 4,450 Times in 1,988 Posts
Sunshine has a reputation beyond repute
Sunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond repute
Default

This is how it looks like
Attached Images
File Type: jpg csv 2 XL.jpg (399.2 KB, 13 views)
__________________
A man who moves a mountain begins by carrying away small stones - Confucius
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 3 Users Say Thank You to Sunshine For This Useful Post:
  #5 (permalink)  
Old 27-11-2016, 08:48 PM
asnavale asnavale is offline
indiTraders VIP
 
Join Date: Jun 2014
Posts: 351
Thanks: 764
Thanked 1,055 Times in 344 Posts
asnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of lightasnavale is a glorious beacon of light
Default

Originally Posted by rsi View Post
Friends,

I need your help. Here is the problem

I have attached the txt format file containing delivery data for BSE stocks. This file is downloaded from BSE itself.

I can also download daily bhavcopy file from BSE. But that file does not contain delivery data.

Therefore, I want to add one more column to the daily bhavcopy file containing delivery data.

I have converted the txt file (containing delivery data) to csv file thinking that by doing so, I can easily copy the entire columns and paste it to bhavcopy file.

But the problem I am facing is that even after converting it to csv file, I am unable to copy paste the data as I am intending. For that matter, data does not get sorted in to columns at all. I am unable to copy and paste the data also.

How to solve this problem?

Your help is greatly appreciated.

Thanks in advance
R. S. Iyer

Iyer, Please see the file from the link below. Is it what you need ?

http://www.4shared.com/file/3b9Z3uKyba/Combined.html

-Anant
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to asnavale For This Useful Post:
  #6 (permalink)  
Old 27-11-2016, 09:26 PM
rsi rsi is offline
indiTraders VIP
 
Join Date: Mar 2009
Posts: 876
Thanks: 949
Thanked 3,693 Times in 809 Posts
rsi has a reputation beyond repute
rsi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond repute
Default

Originally Posted by asnavale View Post
Iyer, Please see the file from the link below. Is it what you need ?

http://www.4shared.com/file/3b9Z3uKyba/Combined.html

-Anant

Exactly. How to get it?

Thanks in advance
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to rsi For This Useful Post:
  #7 (permalink)  
Old 27-11-2016, 09:36 PM
rsi rsi is offline
indiTraders VIP
 
Join Date: Mar 2009
Posts: 876
Thanks: 949
Thanked 3,693 Times in 809 Posts
rsi has a reputation beyond repute
rsi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond repute
Default

Originally Posted by Sunshine View Post
Then manipulate it .

My illiteracy with software language is a handicap. I did not understand your post fully. Can you explain as to how to manipulate it?

Is it in the way in which you explained in your post or is there some other method?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to rsi For This Useful Post:
  #8 (permalink)  
Old 27-11-2016, 09:42 PM
rsi rsi is offline
indiTraders VIP
 
Join Date: Mar 2009
Posts: 876
Thanks: 949
Thanked 3,693 Times in 809 Posts
rsi has a reputation beyond repute
rsi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond repute
Default

Originally Posted by Sunshine View Post
This is how it looks like

Did you try to copy the data?

See the file posted by Ananth.

That is how the final product should be.

Are you able to get it?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to rsi For This Useful Post:
  #9 (permalink)  
Old 28-11-2016, 10:04 AM
rsi rsi is offline
indiTraders VIP
 
Join Date: Mar 2009
Posts: 876
Thanks: 949
Thanked 3,693 Times in 809 Posts
rsi has a reputation beyond repute
rsi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond reputersi has a reputation beyond repute
Default

One more problem in addition to what is described earlier.

Please download the F&O Bhavcopy from NSE or bhavcopy from MCX or NCDEX

They are giving name of the stock in one column and the expiry date of contract in another column.

Now how to assign symbols in the following manner

For contracts expiring in December 2016, say NIFTY, as NIFTY-1

For contracts expiring in January 2017, say NIFTY, as NIFTY-2

For contracts expiring in February 2017, say NIFTY, as NIFTY-3 etc.?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to rsi For This Useful Post:
  #10 (permalink)  
Old 28-11-2016, 10:38 AM
no1lives4ever no1lives4ever is offline
Newbie
 
Join Date: Jul 2009
Posts: 3,388
Thanks: 20,065
Thanked 5,718 Times in 2,432 Posts
no1lives4ever has a reputation beyond repute
no1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond reputeno1lives4ever has a reputation beyond repute
Default

Why not use a bhavcopy downloader?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to no1lives4ever For This Useful Post:
Reply

indiTraders - Forum for the Active Indian Trader > Tools > Data


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


DPonline

All times are GMT +5.5. The time now is 04:14 AM.


vBulletin Copyright by vBulletin

Content Relevant URLs by vBSEO 3.3.2