Great Tutorial! Some may want something more simplified. BUT there are others that need a little more sophistication especially when you want to change the look of your report for Execs. You've just made a report that much more flexible. Thanks! Good job on the VB skills! I haven't done this stuff in a long time and you're tutorials totally helped me in a pinch with my reporting! THANKS!
Hello, I believe that the cvs is not working anymore cause it is showing me an error, even the files that I downloaded from the links in the description of the video, can someone please help me
I just saw your video. Great! I have one question: Yahoo has stopped the ability to download SP500 data. I need this for my spreadsheet. Do you have a fix or algorithm to get the last 5 days ^GSPC?
Hi, I'm trying to use your download stock metrics data, but unfortunately, the URL doesn't exist anymore. Do you have a new Url for the data? Thank you for your videos and to sharing with us.
when I press the button on the file you are supplying it gives me a dialogue box with 400 if I run it with a break mode pressing F8 it works up to the last line and gives 1004 run-time error on the last, why is that?
Yahoo cut off access to the CSV, it no longer exists. I had the same issue and looked into it. Doesn't look as though there are any viable solutions as easy and with as much info as Yahoo.
i know im randomly asking but does anybody know a tool to log back into an Instagram account?? I was stupid forgot the password. I love any tricks you can give me!
@Benedict Skyler i really appreciate your reply. I found the site through google and I'm in the hacking process atm. Looks like it's gonna take quite some time so I will get back to you later with my results.
I downloaded the Pull Metrics.xlsm file & ran it as is. I received a pop-up error that displayed "400". I then opened VB and reviewed the code with your video... it was the same, but when I clicked the Run icon, this error popped-up: "Run-time error '1004': Application-defined or object defined error". This is on a Windows 10 PC running Excel 2010.
Dude this is an awesome video. I'm 67 and deal in options do you have a way to import the option chain including , bid, ask, greeks, intrinsic etc. Comment would be appreciated.
Apparently the URL for Yahoo Finance changed the last two years. Do you have an updated URL for Yahoo? I believe the problem Martin Stoilov is having is due to the wrong URL for Yahoo finance.
I copied the code exactly, when i got to " 'importing data to c6" again this was copied perfectly, yet when i run the macro get get a "Run-time error '1004' = Application-defined or object-defined error " please could someone assist me with why this is? Here is how i have my code set up, maybe there's someone simple I've missed. I am based in UK but used the US tickers in the video, but i don't think that should affect it. 'import data to c6 queryquote: With ActiveSheet.QueryTables.Add(Connection:="URL;" & tickerstring, Destination:=Range("c6")) .BackgroundQuery = True .Refresh BackgroundQuery:=False End With Many thanks in advance
I have input all this code in VBA but I am getting a "Run-Time Error '424' Object Required" error on the very last line of code ".refresh backgroundquery:=False. I have checked the code/spelling/syntax a thousand times but it is definately exactly as you have done it. Help. BTW, every other part of the code works like a charm. I am new to VBA. Am I missing something? Any suggestions?
Hi, thank you for your video, it is clear and understandable. Can you or somebody else please help with an issue I have. I would like to import data from Yahoo Finance, but having in columns other financial data, such as closing price (or adjusted closing price), on a daily frequency level, and a return over a chosen period. Will this be possible ?
Thanks for the video! I was able to make everything work following the video. My question is how do i add Sector and Industry data for each ticker/stock? I have 3 metrics selected to download and tried manually entering the sector and Industry info after my last metric. When i do this all my metrics get bunched up back into column C. What is the simplest way to add Sector and Industry to each ticker i enter? Manual entry is ok as long as I only have to do it once. Once i add a ticker i never delete it, just add more tickers from time to time.
i recently started trading options and joined a trading group. In that group one of the moderators uses a spreed sheet to trade along with charts. Yesterday the market was choppy but looked like a good short. This guy took one look at his spreed sheet and said to go long and with-in 1 min it broke out! Every time he's in the room he uses his spreed sheet to trade from. I use T.O.S for charting and it works great but id like to be able to see that type of detail in the price action. Will this work with FOREX, COMMODITIES AND INDICES OPTIONS?
The program looks like it would work for me but I can not get the import data function to work. Here is a copy of the code. can you tell me what wrong? 'import data to C6 queryquote: With ActiveSheet.QueryTables.Add(Connection:="URL;" & tickerstring, Destination:=Range("C6")) .BackgroundQuery = True .Refresh BackgroundQuery:=False End With Thanks
I was wondering is there a way to stop it from automatically change the width of the columns? Because once I pull the data, the columns changes to a random width. Thanks in advance
I have followed the instructions of this video in Excel 2016 and when I run the macro, I get this error: "Runtime Error 438 Object Doesn't support this Property or Method". I am new to macros and VBA. Any help you can provide is greatly appreciated.
Hi, When I create the macro (or even use yours) it adds an extra column for every decimal place even though I have clearly not done that in the recording. Any suggestions ... or help? Thanks. .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = True .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = True .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(5, 1, 1, 1, 1, 1, 1) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False
Can anyone help?Following the above I am being being able to pull data from NASDAQ, but unable to pull data from NSE, which is one of the Indian stock exchanges. It is returning with N/A
Hi Sir Need One Help in setting up and excel where it Pulls data from nse Data Automatically , and Fits the same into camrilla equationa and refreshes the same at certain fixed time . Its a humble request plsssssssssssss , if you need i can send some specimen links
Great video and easy to follow. I am wondering if there is any other way to clean up the data instead of using the text to column code that is used. That method creates problems if the stock name has a comma included in it. For example, Facebook is Facebook, Inc. so all of the facebook data is shifted over a column from where it should be if I choose "name" as one of the dropdown choices in cell C4. I don't know VBA coding well enough, but is there a different code string that could be used to fix that issue?
The fastest way to fix that is to always have "name" be the last column that you ask for. A much longer way to do it is write a code to check if you searched for name, then check to see which line has more columns than the rest, then recombine the column with name and the one immediately to the right of it. That's much more tedious than just choosing "name" as the last column though. If you want me to show you the long way, just say so and I'll look into it. Thanks for watching!
sir, please tell me one thing that can I retrive live data from yahoo finance because I am going to made a android app so for this I require live data to display in my app. please reply fast because I need help. thank you.
This is crazy amounts of work to grab some data! I mean, I know you are doing it a specific way but all I need to add to my stock watchlist is the current share price. Maybe have it read a ticker symbol I've entered manually, look it up on yahoo finance then bring in the current stock price. I'm not looking to add drop down menus, just have it all auto populate. Is there a way? A really simple way? You would think by now Excel would have thought about this need of people and built a simple way of dong this within the program. What's taking them so long? :)
Oh yeah, I made this to be adjustable to anything you could be looking for, and if you wanted to look for different things in the future. If you know that all you need is the stock price and you know that you're never going to need anything else at all, then there are a couple ways to do it. 1) Google sheets has a built in function for it if you don't care about using Excel. It's the =GoogleFinance() function. 2) You can use this macro: Sub Recent_price() ticker = "MSFT" With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;chart.finance.yahoo.com/table.csv?s=" & ticker & "&a=" & Month(Now() - 1) - 1 & "&b=" & Day(Now() - 1) & "&c=" & Year(Now() - 1) & "&d=" & Month(Now()) - 1 & "&e=" & Day(Now()) & "&f=" & Year(Now()) & "&g=d&ignore=.csv" _ , Destination:=Range("$A$1")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .TextFileColumnDataTypes = Array(9, 9, 9, 9, 9, 9, 1) .Refresh BackgroundQuery:=False End With End Sub Just make sure you change the ticker symbol in the 2nd line to whatever you're going to use. That' gets the most recent close, but I can't find a place that will get it without the heading. That's the most whittled down version I can get. Also you might want to add a line to erase old data that gets left over. I don't know the layout of the sheet you have so I didn't want to write that into it, in case it accidentally deleted your work. It'll import the price to cell A2 and the word "Adj Close" to cell A1.
I think that's a limitation on the part of Yahoo! Finance. They don't supply those data points for Indian stocks. I checked for other countries and I could pull French data (vk.pa) and I could pull German (DDAIY) and I could pull Canadian (BBDB.TO) but I can't get any data from any tickers with a .NS or a .BO extension. I'll need to do some investigating to find out why. In the meantime, check out my most recent video and see if that might solve your problem. It pulls the "Key Statistics" information for stocks, and that has a lot of the same data.
Mate, Looks like it doesnt work any more, I mean the URLs. Being a layman, not sure how do I go about changing the URLs. Do you think you can find some time to update the URLs in your site sites.google.com/site/timevaluevideos/home, that would be widely appreciated. Damn, I bump into all these things way too late. Watching your video was awesome man, you didnt waste no time, you just moved from point A to B to C.... and finished in a zip. Salute you man. Cheers and God Bless you friend.
![[BAEMON NEWS 7] NEW ALBUM COMING IN](http://i.ytimg.com/vi/wtVeAPimOyo/mqdefault.jpg)
You are a star, a highly under-rated channel.
Great Tutorial!
Some may want something more simplified. BUT there are others that need a little more sophistication especially when you want to change the look of your report for Execs.
You've just made a report that much more flexible. Thanks!
Good job on the VB skills!
I haven't done this stuff in a long time and you're tutorials totally helped me in a pinch with my reporting!
THANKS!
Ray Baterina m8
)
Thx u much for the Video. It will helps me out a lot on doing my own stock analysis.
Where could I find the spreadsheet you're using in this example? The files in your comments aren't working either due to the wrong URL. Thanks.
Hello, I believe that the cvs is not working anymore cause it is showing me an error, even the files that I downloaded from the links in the description of the video, can someone please help me
I just saw your video. Great! I have one question: Yahoo has stopped the ability to download SP500 data. I need this for my spreadsheet. Do you have a fix or algorithm to get the last 5 days ^GSPC?
Wow! Great video! Thank you for taking the time to make this! This really helps.
Hi, I'm trying to use your download stock metrics data, but unfortunately, the URL doesn't exist anymore. Do you have a new Url for the data? Thank you for your videos and to sharing with us.
is that possible to download automatically OHLC DATA and OHLC intraday DATA to Excel?
when I press the button on the file you are supplying it gives me a dialogue box with 400
if I run it with a break mode pressing F8 it works up to the last line and gives 1004 run-time error on the last, why is that?
Yahoo cut off access to the CSV, it no longer exists. I had the same issue and looked into it. Doesn't look as though there are any viable solutions as easy and with as much info as Yahoo.
You deserve a medal sir, great job!
i know im randomly asking but does anybody know a tool to log back into an Instagram account??
I was stupid forgot the password. I love any tricks you can give me!
@Josue Andy instablaster :)
@Benedict Skyler i really appreciate your reply. I found the site through google and I'm in the hacking process atm.
Looks like it's gonna take quite some time so I will get back to you later with my results.
@Benedict Skyler it did the trick and I now got access to my account again. I am so happy:D
Thank you so much you saved my ass !
@Josue Andy no problem xD
I downloaded the Pull Metrics.xlsm file & ran it as is. I received a pop-up error that displayed "400". I then opened VB and reviewed the code with your video... it was the same, but when I clicked the Run icon, this error popped-up: "Run-time error '1004': Application-defined or object defined error". This is on a Windows 10 PC running Excel 2010.
did you manage to fix it ? i have the same issue ..
@@saqibsyed7226 Nope... I believe the errors are due to Yahoo Finance changes in the past few years.
Dude this is an awesome video. I'm 67 and deal in options do you have a way to import the option chain including , bid, ask, greeks, intrinsic etc. Comment would be appreciated.
Apparently the URL for Yahoo Finance changed the last two years. Do you have an updated URL for Yahoo? I believe the problem Martin Stoilov is having is due to the wrong URL for Yahoo finance.
did you find the right one?
Great video! Thank you very much for the help
plz guide how to download the stock price index for all the advanced and emerging economies
I copied the code exactly, when i got to " 'importing data to c6" again this was copied perfectly, yet when i run the macro get get a "Run-time error '1004' = Application-defined or object-defined error "
please could someone assist me with why this is?
Here is how i have my code set up, maybe there's someone simple I've missed. I am based in UK but used the US tickers in the video, but i don't think that should affect it.
'import data to c6
queryquote:
With ActiveSheet.QueryTables.Add(Connection:="URL;" & tickerstring, Destination:=Range("c6"))
.BackgroundQuery = True
.Refresh BackgroundQuery:=False
End With
Many thanks in advance
I have input all this code in VBA but I am getting a "Run-Time Error '424' Object Required" error on the very last line of code ".refresh backgroundquery:=False. I have checked the code/spelling/syntax a thousand times but it is definately exactly as you have done it. Help. BTW, every other part of the code works like a charm. I am new to VBA. Am I missing something? Any suggestions?
Hi, Is this spreadsheet available for download ? Thank you.
Hi, thank you for your video, it is clear and understandable. Can you or somebody else please help with an issue I have. I would like to import data from Yahoo Finance, but having in columns other financial data, such as closing price (or adjusted closing price), on a daily frequency level, and a return over a chosen period. Will this be possible ?
Thanks, I was looking for this one, how can I download company profile
Whenever I tried to dump a large list of tickers under the Ticker Title , an error code of 400 came up? Any thoughts?
I received the exact same error....
Thanks for the video! I was able to make everything work following the video. My question is how do i add Sector and Industry data for each ticker/stock? I have 3 metrics selected to download and tried manually entering the sector and Industry info after my last metric. When i do this all my metrics get bunched up back into column C. What is the simplest way to add Sector and Industry to each ticker i enter? Manual entry is ok as long as I only have to do it once. Once i add a ticker i never delete it, just add more tickers from time to time.
i recently started trading options and joined a trading group. In that group one of the moderators uses a spreed sheet to trade along with charts. Yesterday the market was choppy but looked like a good short. This guy took one look at his spreed sheet and said to go long and with-in 1 min it broke out! Every time he's in the room he uses his spreed sheet to trade from. I use T.O.S for charting and it works great but id like to be able to see that type of detail in the price action. Will this work with FOREX, COMMODITIES AND INDICES OPTIONS?
The program looks like it would work for me but I can not get the import data function to work. Here is a copy of the code. can you tell me what wrong?
'import data to C6
queryquote:
With ActiveSheet.QueryTables.Add(Connection:="URL;" & tickerstring, Destination:=Range("C6"))
.BackgroundQuery = True
.Refresh BackgroundQuery:=False
End With
Thanks
I was wondering is there a way to stop it from automatically change the width of the columns? Because once I pull the data, the columns changes to a random width. Thanks in advance
I got a question, is there a way to pull weekly and monthly data like Open, High, Low, Close and Volume?
Can you do this using Excel 2003 ...with live feed
I have followed the instructions of this video in Excel 2016 and when I run the macro, I get this error: "Runtime Error 438 Object Doesn't support this Property or Method". I am new to macros and VBA. Any help you can provide is greatly appreciated.
Hi, When I create the macro (or even use yours) it adds an extra column for every decimal place even though I have clearly not done that in the recording. Any suggestions ... or help? Thanks.
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = True
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(5, 1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
Is this limited to about 200 rows? And is there a way to set it up with out deleting the old data first?
Great video! Is there a way to download >200 lines (Do/Loop function)?
Very Helpful. Thanks!
Greta video I am not able to down load the data can u point me in the right direction
Great tutorial, thanks
Can anyone help?Following the above I am being being able to pull data from NASDAQ, but unable to pull data from NSE, which is one of the Indian stock exchanges. It is returning with N/A
Hi Sir Need One Help in setting up and excel where it Pulls data from nse Data Automatically , and Fits the same into camrilla equationa and refreshes the same at certain fixed time . Its a humble request plsssssssssssss , if you need i can send some specimen links
At the 'import data to c6 I do get an error: Error 1004. Can you tell me what I do wrong here.
Great video and easy to follow. I am wondering if there is any other way to clean up the data instead of using the text to column code that is used. That method creates problems if the stock name has a comma included in it. For example, Facebook is Facebook, Inc. so all of the facebook data is shifted over a column from where it should be if I choose "name" as one of the dropdown choices in cell C4. I don't know VBA coding well enough, but is there a different code string that could be used to fix that issue?
The fastest way to fix that is to always have "name" be the last column that you ask for. A much longer way to do it is write a code to check if you searched for name, then check to see which line has more columns than the rest, then recombine the column with name and the one immediately to the right of it. That's much more tedious than just choosing "name" as the last column though. If you want me to show you the long way, just say so and I'll look into it. Thanks for watching!
sir, please tell me one thing that can I retrive live data from yahoo finance because I am going to made a android app so for this I require live data to display in my app. please reply fast because I need help. thank you.
Do you know how to pull the options chain into excel from Yahoo finance?
Is it possible to add open price to the query?
Thanks for the help setting this up in excel
How can I pull the "name" of FB from finance yahoo? It has a comma in their name. It will trigger strange errors. Help me !
This is crazy amounts of work to grab some data! I mean, I know you are doing it a specific way but all I need to add to my stock watchlist is the current share price. Maybe have it read a ticker symbol I've entered manually, look it up on yahoo finance then bring in the current stock price. I'm not looking to add drop down menus, just have it all auto populate.
Is there a way? A really simple way? You would think by now Excel would have thought about this need of people and built a simple way of dong this within the program. What's taking them so long? :)
Oh yeah, I made this to be adjustable to anything you could be looking for, and if you wanted to look for different things in the future. If you know that all you need is the stock price and you know that you're never going to need anything else at all, then there are a couple ways to do it. 1) Google sheets has a built in function for it if you don't care about using Excel. It's the =GoogleFinance() function. 2) You can use this macro:
Sub Recent_price()
ticker = "MSFT"
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;chart.finance.yahoo.com/table.csv?s=" & ticker & "&a=" & Month(Now() - 1) - 1 & "&b=" & Day(Now() - 1) & "&c=" & Year(Now() - 1) & "&d=" & Month(Now()) - 1 & "&e=" & Day(Now()) & "&f=" & Year(Now()) & "&g=d&ignore=.csv" _
, Destination:=Range("$A$1"))
.TextFileParseType = xlDelimited
.TextFileCommaDelimiter = True
.TextFileColumnDataTypes = Array(9, 9, 9, 9, 9, 9, 1)
.Refresh BackgroundQuery:=False
End With
End Sub
Just make sure you change the ticker symbol in the 2nd line to whatever you're going to use. That' gets the most recent close, but I can't find a place that will get it without the heading. That's the most whittled down version I can get. Also you might want to add a line to erase old data that gets left over. I don't know the layout of the sheet you have so I didn't want to write that into it, in case it accidentally deleted your work. It'll import the price to cell A2 and the word "Adj Close" to cell A1.
please guide me on how to download the data of the stock price index from s and p500
Your tutorial is helpful but Its not working for Indian stock market ,Plz help. Check for AXISBANK.NS or TCS.NS or SBIN.NS or SBIN.BO . Thanks :)
I think that's a limitation on the part of Yahoo! Finance. They don't supply those data points for Indian stocks. I checked for other countries and I could pull French data (vk.pa) and I could pull German (DDAIY) and I could pull Canadian (BBDB.TO) but I can't get any data from any tickers with a .NS or a .BO extension. I'll need to do some investigating to find out why. In the meantime, check out my most recent video and see if that might solve your problem. It pulls the "Key Statistics" information for stocks, and that has a lot of the same data.
Tnx dear for quick reply :)
The yahoo link doesn't work. Could it be updated?
Did you ever find the updated link?
Just a quick thank you for doing this. I can't tell if you are a nerd or a geek but you had me at Sub Matrics_Get! Haha...Thanks again. M
I want to do hundreds of stocks at once. Is there a way to do this using your methods in the video?
please guide me on how to download the stock price index from s and p500
It doesn't work on my sheets. I become frustrated with the program.
Does this no longer work?
Do you figure out the problem? I need a URL for downloading the data
how to add ATP in google sheet or excel for NSE script
i couldn't use it. gives 400 err
great stuff
Can you please upload a new video, I don't think yahoo is working anymore. keep getting errors
Any luck getting a more reliable method?
Yeah he has another video for yahoo that works perfect!
2003 excel vba probably, not working
The site reports the question is not valid...
Error 400 here too
Cant run it 26.04.21. I must be a real noob.
Mate, Looks like it doesnt work any more, I mean the URLs. Being a layman, not sure how do I go about changing the URLs. Do you think you can find some time to update the URLs in your site sites.google.com/site/timevaluevideos/home, that would be widely appreciated. Damn, I bump into all these things way too late. Watching your video was awesome man, you didnt waste no time, you just moved from point A to B to C.... and finished in a zip. Salute you man. Cheers and God Bless you friend.
only for experts may be.............