Question on how to implement business logic
-
Ok guys. I have an idea on how to approach this problem but I wanted to know what's your idea also so that i could check and see if mine is efficient or not.
So here's the question:
If you were integrating a feed of end of day stock price
information (open, high, low, and closing price) for 5,000 companies, how would you do it? You are responsible for the development, rollout and ongoing monitoring and maintenance of the feed. Describe the different methods you considered and why you would recommend your
approach. The feed would be delivered once per trading day in a comma-separated format via an FTP site. The feed will be used by 1000 daily users in a web application.
-
Create a dts package that dumps your cusip/ticker list to a text file, ftp's the list to your data provider, ftp's the prices back and then loads them into the table used by the web app.
You can shedule your dts package to run after market close.
-
Cool thanks for the info! I got a similar plan as yours.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply