Stock chart

[NitinSawant]

Hello experts,
How to embed stock market chart on my website using php?

Actually i want to display last 30 day chart and also current price of stock, pls help

regards,
Nitin

[code green]

jpgraph is worth a look at.
http://www.aditus.nu/jpgraph/jpdownload.php

[prabirchoudhury]

hey you could use gdchart or could you flash and php to do that .

look on those two links
flash _php tutorial

gdchart


good luck :) ..

[NitinSawant]

Hello,
Thanks for your reply.

Drawing graph is no problem, i'm using flot to draw graph http://code.google.com/p/flot/

but i do not know how to retrieve last 30 day stock market data and draw the graph.

regards,
Nitin Sawant

[prabirchoudhury]

1. retrieve the data

select * from table 
where date_field between from_date
AND to_date;

2. then put this data into the graph, this the logic. so where you are having problem ?

[NitinSawant]

Thanks a lot for replying @prabirchoudhury

but i don't have the data in sql tables...

and also at the stock mkts, the data changes every day..

i need data between current day to last 30th day and draw the graph..

i'm stuck in retrieving the data
(is there any website or webservice which offers last 30 day stock market data so that i can manipulate it and draw graph using it?)

[prabirchoudhury]

hey have a look on might help you

stock database

free download

or make a dummy database with all the possible fields and do the testing untill you get the better one

good luck..

[NitinSawant]

still have problems @prabirchoudhury

The link which you posted is windows app,

and i'm tryin to develop web app,

nd also i want realtime data in it

[prabirchoudhury]

sorry i couldn’t help on that but frm those links you could get some idea of real-time data fields ..

[NitinSawant]

what to do now? there must be some kind of service which will help me to do the task?