hmp said:
Dear Satish
Thanks For Software. Excellant Attempt!
I Downloaded Latest Essar Oil Data.though Its Up 4.72% On 30 June In Ur Software It Shows Red. Pl. Explain.
Regards
Hmp
Hmp,
I am not sure what you mean here? Are you talking about profit/loss %. This is done by calculating the today's price and subtracting the buy price and looking at what percentage it is from the buy price. For example you bought 100 quantity of a scrip at 100, and today its value is 150, the profit is 5000. and profit% is 50%. It has not got to do with stocks gain/loss% today.
On the other hand, color coding of the scrips daily price/volume movement is based on the previous EOD data of the scrip in the previous column alone (Hopefully you refreshed after close of market the previous date so you have EOD data of the previous date in the previous column).
If you want this to reflect the right color as per the price movement, you need to hit GET DATA on a daily basis after market close, so that you have the EOD data of those scrips and on the next day the change is identified clearly either by Red or Green.
During market hours, if you are logged in to finance.yahoo.com, this will give live quotes else delayed by 20 minutes, so you could use this as a ticker too. I use this very much in my office hours where I cannot login to nse or bse or broker sites...
Am I clear?? Did I miss something? Reply back if that is the case..
Good luck.
Satish