Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Auto Import Stock from Yahoo Finance to MS SQL
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

181 Posts

Posted - 02/18/2014 :  02:30:06  Show Profile  Visit daipayan's Homepage  Send daipayan a Yahoo! Message  Reply with Quote
Hello there,

I am facing a issue in importing CSV file to my MS SQL Table.

Let me explain my problem:

I have 2 tables:- 1# Stock_Symbol 2# Stock_Symbol_Daily_Quotes

In Stock_Symbol there are 2 columns - Stock_ID & Stock_Name
In Stock_Symbol_Daily_Quotes there are ID; Stock_ID; Price; Time; Date; High; Low; etc.

From the following link - I am manually can get any stock information as CSV.

But I want to do this automatically and directly to Stock_Symbol_Daily_Quotes table. I am seeking for some T-SQL which will allow me to download the stock price in every 15 minutes.
BBDB.TO+NT.TO+GE+MSFT - this will come directly from Stock_Symbol table.

Is there a way to do that, I tried lot of option, I know if the csv file located locally I can do the import and doing dynamically and directly from web is what I am not able to do that.

Hope I am able to make you understand my query, please help me.

Software Analyst

Application has reported a 'Not My Fault' in module KRNL.EXE in line 0200:103F

Edited by - daipayan on 02/19/2014 01:10:32
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000