Below procedure can be used to get the stock information from yahoo finance.
Sub getYahooFinance()
'Below script will download the quotes for given symbol from yahoo finance
'more info at -> http://www.jarloo.com/yahoo_finance/
'qURL = "http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT&f=nv"
'http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT&f=nv
qURL = "http://ichart.finance.yahoo.com/table.csv?s=rcom.BO&ignore=.csv"
With Sheet1.QueryTables.Add(Connection:="URL;" & qURL, Destination:=Sheet1.Range("A1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
Sub getYahooFinance()
'Below script will download the quotes for given symbol from yahoo finance
'more info at -> http://www.jarloo.com/yahoo_finance/
'qURL = "http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT&f=nv"
'http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT&f=nv
qURL = "http://ichart.finance.yahoo.com/table.csv?s=rcom.BO&ignore=.csv"
With Sheet1.QueryTables.Add(Connection:="URL;" & qURL, Destination:=Sheet1.Range("A1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
BigProfitbuzz is an Indian stock market advisory firm. BigProfitbuzz proven month after month that trading and investing in stock market can be profitable whether market is bull or bear. As suggested last week our all client made a very good profit in the sell position of NIFTY. Now for the coming BSE STOCK TIPS week we suggest all the traders to make a buy position in NIFTY around 5850-5950 with stoploss 5700 for the target of 6200-6300.This is due to that NIFTY is has completed is consolidation phase. You can also can make buy position in NIFTY stocks also. But keep the strict stoploss of 5700 for the NIFTY & NIFTY stocks. For further update visit our website.
ReplyDeleteRegards
BIGPROFITBUZZ TEAM
By this line, it is displaying some error message. Should I set something under references?
ReplyDeleteWith Sheet1.QueryTables.Add(Connection:="URL;" & qURL, Destination:=Sheet1.Range("A1"))