XML?
Jun 24, 2012 at 8:51am UTC
hi.
I have started my own project, to develope a small Stock trading bot. Mostly for the learning of doing it, but since i trade manually now i am not shy to later go active with it.
I get my data about stocks in XML format, which seems to be the best format to use. I am having a problem finding a good working XML-parser for Mac. Not realy sure how to write one by myself either.
The only thing i need is to read XML-format that looks like the one below, no need to write to XML.
I would think it would be quite easy to code it by myself, but not realy sure how to start. How to get it to skip the first part of the XML-file.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
<?xml version="1.0" ?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40" >
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office" >
<LastAuthor>72-47 21 05</LastAuthor>
<Created>2012-06-13T14:03:20Z</Created>
<Version>14.0</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office" >
<AllowPNG/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel" >
<WindowHeight>10760</WindowHeight>
<WindowWidth>25600</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>0</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal" >
<Alignment ss:Vertical="Bottom" />
<Borders/>
<Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="12" ss:Color="#000000" />
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s63" >
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1" />
<Font ss:FontName="Calibri" ss:Color="#000000" ss:Bold="1" />
</Style>
<Style ss:ID="s66" >
<Alignment ss:Vertical="Bottom" ss:WrapText="1" />
<Font ss:FontName="Calibri" ss:Color="#000000" />
<NumberFormat ss:Format="Short Date" />
</Style>
<Style ss:ID="s67" >
<Alignment ss:Vertical="Bottom" ss:WrapText="1" />
</Style>
<Style ss:ID="s68" >
<Alignment ss:Vertical="Bottom" ss:WrapText="1" />
<Font ss:FontName="Calibri" ss:Color="#000000" />
</Style>
</Styles>
<Worksheet ss:Name="Sheet1" >
<Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="257" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="65" ss:DefaultRowHeight="15" >
<Column ss:Width="80" />
<Column ss:Width="57" />
<Column ss:Width="54" />
<Column ss:Width="57" />
<Column ss:Index="6" ss:Width="48" />
<Column ss:Width="58" />
<Column ss:Width="34" />
<Row>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Datum</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Högsta kurs</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Lägsta kurs</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Stängn.kurs</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Average price</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Tot. vol.</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Oms</Data></Cell>
<Cell ss:StyleID="s63" ><Data ss:Type="String" >Avslut</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s66" ><Data ss:Type="DateTime" >2011-06-13T00:00:00.000</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="Number" >85.05</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="Number" >84</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="Number" >84.5</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="Number" >84.68</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="String" >10 747</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="String" >910 031</Data></Cell>
<Cell ss:StyleID="s68" ><Data ss:Type="Number" >56</Data></Cell>
</Row>
Topic archived. No new replies allowed.