REQUEST : pib market watch to excel importing

[hitman007]

Hi friends,

can anyone please help me how can i continuously import data from pib market watch to excel sheet . It doesnt matter even if excel data is over written by pib latest data while importing. please help me .

 

[omkarmango]

Hi friends,

can anyone please help me how can i continuously import data from pib market watch to excel sheet . It doesnt matter even if excel data is over written by pib latest data while importing. please help me .

Thats very easy indeed.
Send me mail on ****@***.com
Choose from, credit card / paypal / wire transfer
Send me Rs.****/- only
I'll tell you the solution.




OR


Open Excel,

go to Data>Import External Data>New database query>

give there path for your csv files of PIB data . i.e. your PIB data folder.

say Add

Double click on <New Data Source>
Fill following Info

1> PIB
2> Select first option for csv & txt
3> connect>options>csv>ok
4> no need to fill

say OK

Now PIB should be their in the list

say OK

Query Wizard will open

On left, there will be file names of the scrips.
click on + of a file.
add every item to right.

click Next>next>Next>finish

click ok

Data will be there

Whenever want to refresh, go to Data>refresh

or make macro for that.

Omkar

 

[hitman007]

Hi omkar ,

Thanks a lot for giving me valuable information. this is knowledge update to me . But actually i didnt me that .(excuse me if i couldn't express in right way)

My problem is when we open pib and our maket watch in pib . we press ctrl+s to export data in csv format , i want to export data to csv file( in data folder) from pib market watch continously . everytime i press ctrl+s to export which should be avoided .

Please suggest me some method or any utlity which do this .

Thanks

 

[jdm]

hhhmm, pib is dde enabled, it would be much better if one uses the same. the problem is i dont know the link items. it will go like this; =PROGMAN|PROGMAN!(missing input) search the net to find the missing inputs or send a mail to helpdesk, for the link items. and ofcourse if you get to know do let me know

 

[tejvish]

Thats very easy indeed.
Send me mail on ****@***.com
Choose from, credit card / paypal / wire transfer
Send me Rs.****/- only
I'll tell you the solution.




OR


Open Excel,

go to Data>Import External Data>New database query>

give there path for your csv files of PIB data . i.e. your PIB data folder.

say Add

Double click on <New Data Source>
Fill following Info

1> PIB
2> Select first option for csv & txt
3> connect>options>csv>ok
4> no need to fill

say OK

Now PIB should be their in the list

say OK

Query Wizard will open

On left, there will be file names of the scrips.
click on + of a file.
add every item to right.

click Next>next>Next>finish

click ok

Data will be there

Whenever want to refresh, go to Data>refresh

or make macro for that.

Omkar

i tried as u said but when i add more then one stock it say u need to merge them by draging manually i didnt understand what to do.
here the name also doesnt come so how to add these as data feed.

 

[arunjit.banerjee]

Dear Omkarmango,

I appreciate efforts of people like you who have made traderji.com a unique place to help newcomers and professionals share their views and help each other with valuable informations. Your guidance on PIB market watch to excel importing is commendable , but i am facing some problems for which i am not getting the desired result . Can you please guide me on where can i get the " path for my csv files of PIB data ". my mail i.d. is [email protected] and yahoo i.d. is [email protected]. Kindly help me and it would be gr8 if i could get your mail i.d. so that i can get your guidance much more faster.

Thanks a ton for your help,

Rgds,

Arunjit Banerjee