Updating the stacked line plot with the most recent data

I just created a stacked line plot. https://plot.ly/~shparekh/15/market-trend-vs-time/ And that is great.

How do I update the chart with the most recent data. Ideally, it would be great if I could simply link the google spreadsheet that is continuously updated with the data.

Thank you.
Best regards,
Sanjay

Do you want to update that graph using an API or our web app?

e.g. from our python API: https://plot.ly/python/file-options/

our Web app: http://help.plot.ly/update-a-graphs-data/

and note that the new version of our web app will make updating data much easier.

Thank you. I am looking for a more automated solution but this good to know.
Best regards,
Sanjay