| Author |
Message |
vivekkumar_in
Senior Member
Joined: 19/Sep/2006
Location: United States
Online Status: Offline
Posts: 606
|
   Posted: 26/Jan/2007 at 10:39pm |
|
Thanks a bunch Bubble ji .. & Thanks for the prompt reply too..
Have a nice week end !
|
|
Often we forget there's a company behind every stock,and there's only one reason why stocks go up. Companies go from doing poorly to doing well or small companies grow to large companies.
P Lynch
|
 IP Logged |
|
|
|
 |
|
omshivaya
Senior Member
Joined: 06/Sep/2006
Location: India
Online Status: Offline
Posts: 5966
|
Posted: 27/Jan/2007 at 2:39pm |
Vivek ji,
Do the following steps to make the process automatic(of downloading the latest BSE data onto your excel file):
1) Open Microsoft Excel
2) Go to Tools -> Macro -> Record New Macro
3) Choose any keyboard shortcut, such as Control A or whatever you like. Do remember this shortcut for later on.
4) Click on Data -> Import External Data -> New Web Query
6) Click OK.
7) After sometime, the data should be retrieved from the above webpage. 8) Now, go to: Tools -> Macro -> Stop Recording
9) Save the file with whatever name you like.
Next time you open the file, remember to press the macro shortcut. Ctrl+A if you chose the same.
Added notes: The security in Excel should be allowed to "Run Macros". In some systems, the system may be setup not to run Macros. Do Enable Macros, do the following:
1) Tools -> Options -> Security
2) Choose Macro Security
3) Choose Security Level tab and "Medium". Press OK.
This should take care of the BseIndia marketwatch.asp webpage.
Hope this helps!
|
|
The most important quality for an investor is temperament,not intellect.A temperament that neither derives great pleasure from being with the crowd nor against it
|
|
IP Logged |
|
|
|
omshivaya
Senior Member
Joined: 06/Sep/2006
Location: India
Online Status: Offline
Posts: 5966
|
Posted: 27/Jan/2007 at 2:49pm |
Alternatively, you can download a file I have created: http://geocities.com/graphic_indian/dwnld/bseindiamarketwatch.xls
and save the file to your hard disk. Make sure that your Excel has "Macro Enabled". If not, then to enable Macros follow what I wrote in the above msg.
The shortcut for the macro in my excel file is: Control + Shift +A
Best would be to download the daily End of Data from NSEINDIA for free and then chart it easily in Excel(which I am sure you know fully).
|
|
The most important quality for an investor is temperament,not intellect.A temperament that neither derives great pleasure from being with the crowd nor against it
|
|
IP Logged |
|
|
|
BubbleVision
Senior Member
Joined: 05/Aug/2006
Location: India
Online Status: Offline
Posts: 3142
|
Posted: 27/Jan/2007 at 10:28pm |
|
Om - can yo make a macro for coping the Last value in an array to a new line / sheet in Excel....The only limititation of excel is that it cannot take the last value for an array function.
|
|
You can't make money if you are unwilling to lose...It's like willing to breathe in but not willing to breathe out. -- ED SEYKOTA ....Read Disclaimer!
|
|
IP Logged |
|
|
|
vivekkumar_in
Senior Member
Joined: 19/Sep/2006
Location: United States
Online Status: Offline
Posts: 606
|
Posted: 27/Jan/2007 at 11:30pm |
Originally posted by omshivaya
Vivek ji,
Do the following steps to make the process automatic(of downloading the latest BSE data onto your excel file):
1) Open Microsoft Excel
2) Go to Tools -> Macro -> Record New Macro
3) Choose any keyboard shortcut, such as Control A or whatever you like. Do remember this shortcut for later on.
4) Click on Data -> Import External Data -> New Web Query
6) Click OK.
7) After sometime, the data should be retrieved from the above webpage. 8) Now, go to: Tools -> Macro -> Stop Recording
9) Save the file with whatever name you like.
Next time you open the file, remember to press the macro shortcut. Ctrl+A if you chose the same.
|
Om Ji,
This is cool.. I got the indexes thru the macro you suggested. Thanks ! and thanks for sharing your IP excel with me..
Is there anyplace from where we could download the daily historical prices of stocks ?
Warm Regards,
Vivek
|
|
Often we forget there's a company behind every stock,and there's only one reason why stocks go up. Companies go from doing poorly to doing well or small companies grow to large companies.
P Lynch
|
|
IP Logged |
|
|
|
omshivaya
Senior Member
Joined: 06/Sep/2006
Location: India
Online Status: Offline
Posts: 5966
|
Posted: 27/Jan/2007 at 11:56pm |
Originally posted by vivekkumar_in
Originally posted by omshivaya
Vivek ji,
Do the following steps to make the process automatic(of downloading the latest BSE data onto your excel file):
1) Open Microsoft Excel
2) Go to Tools -> Macro -> Record New Macro
3) Choose any keyboard shortcut, such as Control A or whatever you like. Do remember this shortcut for later on.
4) Click on Data -> Import External Data -> New Web Query
6) Click OK.
7) After sometime, the data should be retrieved from the above webpage. 8) Now, go to: Tools -> Macro -> Stop Recording
9) Save the file with whatever name you like.
Next time you open the file, remember to press the macro shortcut. Ctrl+A if you chose the same.
|
Om Ji,
This is cool.. I got the indexes thru the macro you suggested. Thanks ! and thanks for sharing your IP excel with me..
Is there anyplace from where we could download the daily historical prices of stocks ?
Warm Regards,
Vivek |
You have to check out the rest. Maybe Bubble ji can help further in this.
Edited by omshivaya - 27/Jan/2007 at 12:11pm
|
|
The most important quality for an investor is temperament,not intellect.A temperament that neither derives great pleasure from being with the crowd nor against it
|
|
IP Logged |
|
|
|
omshivaya
Senior Member
Joined: 06/Sep/2006
Location: India
Online Status: Offline
Posts: 5966
|
Posted: 27/Jan/2007 at 11:59pm |
Originally posted by BubbleVision
Om - can yo make a macro for coping the Last value in an array to a new line / sheet in Excel....The only limititation of excel is that it cannot take the last value for an array function. |
I am not much of an expert, but usually arrays start with a 0 index value instead of a 1 and hence the last element would be referred by actually the array size-1, as the index starts with 0. Some newbies refer the last element of the array with the array size. That is, if the array length is 5, they try to access it with array[5], instead of array[4]. array[5] in most arrays(in java etc.) would give a NULL or ERROR value probably.
Again, I am a novice at this. Just sharing what all I have learnt from other experts.
If you can provide an example of an array(with the code for the array creation specifically, then I can try something just for luck and let you know if anything can be done. No promises though!
Hope it helps!
Edited by omshivaya - 27/Jan/2007 at 12:03pm
|
|
The most important quality for an investor is temperament,not intellect.A temperament that neither derives great pleasure from being with the crowd nor against it
|
|
IP Logged |
|
|
|
values
Senior Member
Joined: 02/Jan/2011
Location: India
Online Status: Offline
Posts: 313
|
Posted: 16/Jan/2011 at 1:52pm |
Originally posted by BubbleVision
For that you need to create a Macro (i got it done through Visual Basic) the Tech guys here may help... That could download the BSE INDICES data from http://www.bseindia.com/mktlive/mktwatch.asp directly on excel using the link on excel and paste all the indices data directly on respective excel sheets. Then you can create the charts however if you need indicators then you need to calc them on excel and then post them on Excel chart sheet.
My Indices programme Runs like this ... and for Stock i look on my softwares... I have Metastock, Advanced Get or Trends...(I have all the original softwares)...
Stock prices are also available on nse india in Excel to download
For the most cheap option ....suscribe to any data vendors like Viratech who could provide daily data and pirated Metastock.
There are people in Kolkata who are giving better service than Viratech at 1/2 the cost however they would not be able to service a US based guy as they are realy small...they charge Rs 5000/- for same thing which viratech gives for Rs 10000/-
|
BubbleVision
How do you analyze individual stocks on metastock ? do you import the
data for individual scrips on metastock ? can you share that process ?
|
|
IP Logged |
|
|
|
Active Topics
Memberlist
Calendar
Search
Help
Register
Login
