HTML question from a web-building idiot

[DuffmanOhYeah]

Let me start by saying that I work for a Hedge fund. What we are trying to do is have our p&l (what we are up or down for the day) published so our portfolio manager can keep track of it from the road.

We had a guy from one of our partners build an excel spreadsheet that updates and keeps track of our positions, and that spreadsheet is in turn created as an html page every minute so we can view it over the company intranet.

No I am wondering how hard it would be to take that html sheet and have it published every 3 minutes or so to a server so our boss can see it.

Our system consultants dont want to touch it, but they suck anyway.

How hard could this possibly be?

 

[DuffmanOhYeah]

eh?

 

[ragazzo]

ftp scheduler?

why not use php & mysql?

 

[DuffmanOhYeah]

Originally posted by: ragazzo
ftp scheduler?

why not use php & mysql?

I would, but I know pretty much squat. Seriously, out system consultants suck ass, so I am trying to do what I can on my own.

And I have no idea how hard it would be to use php and or mysql.

I like the ftp scheduler idea though. Unless the php idea is worlds better. I really have no idea.

 

[notfred]

If you want to subcontract it to me I can develop a very professional solution. Not for free, of course.

 

[Ness]

There are multiple ways to go about this. One of the most simple would be to write a small app. that uploads the spreadsheet to the site every 3 minutes, and have that run from wherever the sheet is stored, obviously.


(edit: simple in thought, not quite execution.)

 

[rh71]

what exactly is the source of this P&I data ? Don't tell me it's just a manually created/updated spreadsheet ..

 

[DuffmanOhYeah]

Originally posted by: rh71
what exactly is the source of this P&I data ? Don't tell me it's just a manually created/updated spreadsheet ..

all data are pulled in via live feed from two sources, our prime-broker, and Bloomberg for live pricing. That is what is dumped into a spreadsheet. That sheet is then turned into an html sheet about once every minute. It is that sheet (or a copy of it) that I would like to post online.

 

[DuffmanOhYeah]

Thanks for the help everyone. I think we are just going to get a copy of CuteFTP pro and have the scheduler feature kick up and replace the page every minute.