Need computer programming help K for an answer

[needtogetarmy]

I have dome data from stock trading systems that is in XML format and I need to extract it to an excel spreadsheet (or something similar) so I can manipulate it with an econometric stat program.

Basically the code looks like this:

<system>
<id>204639</id>
<name>The Taleb Factor</name>
<agedays>1384.53</agedays>
<numsigs>36</numsigs>
<startcash>100000</startcash>
<win>2367.36</win>
<loss>47050</loss>
<c2userid>204606</c2userid>
</system>

What I need to do is to pull the data in between the brackets above and throw it all in columns / rows of a spread sheet. I have 6000 trading systems and millions of transactions to process.

Any help would be appreciated.

 

[Razorguns]

I have dome data from stock trading systems that is in XML format and I need to extract it to an excel spreadsheet (or something similar) so I can manipulate it with an econometric stat program.

Basically the code looks like this:

<system>
<id>204639</id>
<name>The Taleb Factor</name>
<agedays>1384.53</agedays>
<numsigs>36</numsigs>
<startcash>100000</startcash>
<win>2367.36</win>
<loss>47050</loss>
<c2userid>204606</c2userid>
</system>

What I need to do is to pull the data in between the brackets above and throw it all in columns / rows of a spread sheet. I have 6000 trading systems and millions of transactions to process.

Any help would be appreciated.

Uses MS Access. I think other office apps can import xml too.

r

 

[needtogetarmy]

Uses MS Access. I think other office apps can import xml too.

r

Thanks. I'll give that a swing since I have some experience with it.

One big problem I have is I need it all automated. It will take me forever to go through 6000 systems. Maybe I need to break out the old MS Visual Basic. It has been over 8 years since I have programed. Yuck.

If anyone know of an automated program that is better post up.

 

[puddlemonkey]

bump for my buddy

 

[walliwalibus]

Smack and a bump.............

 

[Razorguns]

Thanks. I'll give that a swing since I have some experience with it.

One big problem I have is I need it all automated. It will take me forever to go through 6000 systems. Maybe I need to break out the old MS Visual Basic. It has been over 8 years since I have programed. Yuck.

If anyone know of an automated program that is better post up.

Define automated. Do you have 6000 xml files in a directory and need to auto-import into tables? You can probably find a utility somewhere online and then create a batch file/use a batch program.

r

 

[needtogetarmy]

Define automated. Do you have 6000 xml files in a directory and need to auto-import into tables? You can probably find a utility somewhere online and then create a batch file/use a batch program.

r

Yeah.

This is how it is broken down. I have one web page (and XML file) that has the names and ID numbers for each trading system. From that I can pull the numbers for each system.

After that I need to pull the data for each system which is through a different command.

 

[needtogetarmy]

I just got an answer from the SAS tech support people and I can import it directly to SAS.

K to Razorguns for being a good bor.

 

[Razorguns]

Yeah.

This is how it is broken down. I have one web page (and XML file) that has the names and ID numbers for each trading system. From that I can pull the numbers for each system.

After that I need to pull the data for each system which is through a different command.

You have a webpage where you pick a system and then you import a xml file dynamically? Looks like more of the work is dynamic through your web page - and then the xml import. Since it's dynamic you'll have to do some coding then (.net, java, classic asp)

r

 

[needtogetarmy]

You have a webpage where you pick a system and then you import a xml file dynamically? Looks like more of the work is dynamic through your web page - and then the xml import. Since it's dynamic you'll have to do some coding then (.net, java, classic asp)

r

I tried SAS but it is not very robust to different XML headings. I ended up using Excel and it worked with total ease.

I probably will have to do some programing if I want this automated. Inserting the system ID for each trading system to pull down all of their records is going to be a pain (and time consuming). I just finished pulling down the data for one system and it took about 10 minutes to do everything (it has over 5000 entries). I am thinking Access will be better.

 

[Razorguns]

I tried SAS but it is not very robust to different XML headings. I ended up using Excel and it worked with total ease.

I probably will have to do some programing if I want this automated. Inserting the system ID for each trading system to pull down all of their records is going to be a pain (and time consuming). I just finished pulling down the data for one system and it took about 10 minutes to do everything (it has over 5000 entries). I am thinking Access will be better.

Cool. I think MS BizTalk is all about data access to multiple data systems. But if u don't to be dynamic with asp/vbscript or javascript - yeah Excel would work.

r