SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Auto Import Stock from Yahoo Finance to MS SQL
 New Topic  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 - http://finance.yahoo.com/d/quotes.csv?s=BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr 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  
 New 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.03 seconds. Powered By: Snitz Forums 2000