Need help in getting data

vssoma

vssoma

Well-Known Member
#1
#1
dear,
i am trying to build( practicing VBA) a sheet which downloads two stocks data from yahoo.
pls find the sheet below as attached.

http://ww w. 4 shared . com/ file/ PWgLsj1lba/ try-2014.html

( remove spaces)

the sheet actually downloads the data but not two stocks. it's downloading only one stock data and pasting it in to two sheets.

any vba experts, pls check my code and tell me where i did mistake and how can i correct.
thank you.
 
manishchan

manishchan

Well-Known Member
#2
#2
vssoma said:
dear,
i am trying to build( practicing VBA) a sheet which downloads two stocks data from yahoo.
pls find the sheet below as attached.

http://ww w. 4 shared . com/ file/ PWgLsj1lba/ try-2014.html

( remove spaces)

the sheet actually downloads the data but not two stocks. it's downloading only one stock data and pasting it in to two sheets.

any vba experts, pls check my code and tell me where i did mistake and how can i correct.
thank you.
Click to expand...
What exactly are you trying to download.... just the stock price... or OHLC data ? The link you gave is not working.
 
vssoma

vssoma

Well-Known Member
#3
#3
manishchan said:
What exactly are you trying to download.... just the stock price... or OHLC data ? The link you gave is not working.
Click to expand...
dear,
i want to download daily stock1 prices(OHLC) in one sheet and stock2 daily prices(OHLC) in another sheet.
by the way, link is opening for me

http://www. 4shared. com/file/PWgLsj1lba/try-2014.html


 
Last edited:
manishchan

manishchan

Well-Known Member
#4
#4
vssoma said:
dear,
i want to download daily stock1 prices(OHLC) in one sheet and stock2 daily prices(OHLC) in another sheet.
by the way, link is opening for me

http://www. 4shared. com/file/PWgLsj1lba/try-2014.html


Click to expand...
If you want just the OHLC data.. you can download from google finance. Search fro google finance hisotorical data. you can just do web querry. No need for VBA
 
vssoma

vssoma

Well-Known Member
#5
#5
manishchan said:
If you want just the OHLC data.. you can download from google finance. Search fro google finance hisotorical data. you can just do web querry. No need for VBA
Click to expand...
dear, here in this place web query will not work. because, i'll change from n to date....in google finance it has multiple data and web quere will show u only 1 page...to download multiple pages this method is only the solution which i used.

this method i copied from net only...but that has only one stock at a time. but here i want two stocks at same time.

hope i explained clearly...
 
josh1

josh1

Well-Known Member
#6
#6
Change your second query to this ....

Code: 
qurl2 = qurl2 & "&a=" & Month(StartDate) - 1 & "&b=" & Day(StartDate) & _
       "&c=" & Year(StartDate) & "&d=" & Month(EndDate) - 1 & "&e=" & _
       Day(EndDate) & "&f=" & Year(EndDate) & "&g=" & Sheets("S2").Range("a2") & "&q=q&y=0&z=" & _
       Symbol2 & "&x=.csv"
 
vssoma

vssoma

Well-Known Member
#7
#7
josh1 said:
Change your second query to this ....

Code: 
qurl2 = qurl2 & "&a=" & Month(StartDate) - 1 & "&b=" & Day(StartDate) & _
       "&c=" & Year(StartDate) & "&d=" & Month(EndDate) - 1 & "&e=" & _
       Day(EndDate) & "&f=" & Year(EndDate) & "&g=" & Sheets("S2").Range("a2") & "&q=q&y=0&z=" & _
       Symbol2 & "&x=.csv"
Click to expand...
dear,
thank you josh, it's working fine...
 
josh1

josh1

Well-Known Member
#8
#8
vssoma said:
dear,
thank you josh, it's working fine...
Click to expand...
For multiple stocks, you can put single query in a for .. next loop and change the destination sheet accordingly.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N need help get open positions of day before AmiBroker 0
G Need Help with converting this Pinescript to AFL AmiBroker 0
A Need Help in Getting an AFL AmiBroker 4
A Downloaded amibroker, need help getting started AmiBroker 5
M Need help with getting Historical data in QT Data Feeds 1

Similar threads