RE: Converting xls generated xml to FusionCharts XML format for candlestick charts

Pallav — Mon, 03 Dec 2007 16:32:03 GMT

Michael,

You may write a script in any of the scripting languages to do this automatic conversion.

Converting xls generated xml to FusionCharts XML format for candlestick charts

mfowler1 — Mon, 26 Nov 2007 16:40:49 GMT

Hi,

I want to use stock price information from Yahoo Finance which is delivered in xls format. I am having problems converting the spreadsheet data (symbol, date, open, high, low, close, volume) into a FusionCharts compatible xml format.

The xml I generate looks similar to this:

etc

Fusion charts uses a single line with multiple attributes:

Can anyone recommend an XML tool to convert XLS to XML in the correct format?

Many thanks,

Michael

FusionCharts Forum / FusionCharts v3 / Using FusionCharts / XML Issue / Converting xls generated xml to FusionCharts XML format for candlestick charts / Latest Posts

RE: Converting xls generated xml to FusionCharts XML format for candlestick charts

Converting xls generated xml to FusionCharts XML format for candlestick charts