Re: Better way of inserting lots of data?

[Paul St . Amant]

Thanks for the reply.  I got bogged down and am only now getting back to the db stuff.  Yes. I downloaded the historical data from yahoo and organized it in Excel.  I also use the built in web queries feature in Excel to grab data from MSN.  The stockgrabber custom tag also works well for delayed quotes.  The reason I like using CF is for the built in charting.  What I am trying to do is create a custom stock index that is updated daily.  It is really quite easy with so many datafeeds.  Once the historicals are in the database, updating the daily closing prices takes only a few lines of code.  The only issue comes in when I want to add a company to the index and have to upload a few years of closing prices, which seems reasonable using the bulk insert.

Paul

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---