SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

daipayan
Posting Yak Master

India
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.

Regards,
Daipayan
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.23 seconds. Powered By: Snitz Forums 2000