I respond rare to videos. But here I feel obliged. WHAT A FANTASTIC, SMART VIDEO, espescially for Mac users to get data from YAHOO FINANCE! And this without much fuss. Shame that Steve Jobs probably will not have seen this handsome, useful MAC-work ... Thank you very much for publishing this video, Andrés.
Great work sir. You have made some difficult programming very easy to follow and duplicate. Looking forward to more videos from you. May force be with you, ALWAYS-->
Andres, thanks for sharing. I've been able to make this work following your detailed instructions. Can you please guide me through the steps to add Fx quotes for major currencies. Many thanks.
Hi Andreas, seems to have got the formula working but I used the LAST PRICE which pertains to the price the security closed at the prior day. Which symbol would I use for real time price (the current price )??. Thank you
Thanks Andreas, the .L work fine with all UK stocks on Google. I can't seem to find the right symbols to download the Dow Jones Industrial nor the FTSE 100. Any ideas? Thanks again for all your advise, it has been really very helpful.
Hey, thank for this great video! Unfortunately, I had some mistakes with the terminal. I wrote everything like you in the terminal and then I saved it. But I cannot find my file I have created - Maybe I didn´t create anyone? Or can you please tell me which sign did you wrote before "curl -o ..." I just made a space?
Thanks Andrés! Very clearly explained tutorial! I just have another question. How can I put a space between the stocks? Is there a certain symbol for this? I've tried to put a space between 2 commas (AAPL, ,GOOGL). but it didn't work. It is because I have spaces in my excel file. Kind Regards, Benoit
Two days ago, the quotes.txt file stopped updating even though the runNow file worked fine and updated every 20 seconds. I remade the runNow executable but it will not create the quote.txt file. Can you please help.Using Excel 15.24 on a new Macbook.
Hi Andreas, I have never programmed anything before but managed to get the stock quotes working perfectly by carefully following your instructions. Many thanks. However, I cannot seem to retrieve any stocks from the UK market (Footsie 100). I can find them on the Google Finance pages (e.g. UK:BP) but cannot find the correct symbol to retrieve them with runNow. Any ideas?
Hi Andreas, UK stock quotes are available on both Google Finance and Yahoo Finance on their web pages. You showed how to retrieve from Google, perhaps I could try from Yahoo if you let me know how to edit Yahoo into runNow.
Thanks for the reply. However can we not program excell to update auto when it is synchronised to the txt file rather than the person having to go through the manual labor.
Know bits and pieces of Excel. Q: Any other way to getting live price updates on Excel? If not, does running the executable file become heavy on the Mac OS?
Hi Andres, maybe im getting old but it seems millennials are inherently tech-savvy, well done. My question to you is, how would I obtain parameters for an alternate website? like if I wanted to import hourly search results for say domain.com real estate listings in my area?
Their seems to a bug/issue, When the executable file is running and the data has been brought back to the quote.txt file (WHICH IS ACCURATE AND DECIMALISED), when you then import the quotes file into the spreadsheet it does NOT arrive formatted properly. ie GOOG outstanding shares is 678,365,000 (which is appears correctly in the quotes file. However when I import that data to the excel spreadsheet, Its arrives as only as 678. Any help would be appreciated. Like wise data from other symbols does the same and thus the whole thing is skewed.
Hi Andres, i download all your files, and when i doubleclick the "runNow" file, windows10 is asking me in wich app i would like to open this file? Can you help please......
FABULOUS! How could I list all symbols (about 700) in a spreadsheet column and have the program reference the range in order to get the desired information as opposed to typing all the symbols into the program?
***** Here is the Excel Query that worked for years. See if it helps! WEB 1 moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."] Selection=EntirePage Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False
Does anyone know the solution for the quote.txt problem? I can get the program to update, but to where? It is not executing the first command to create a text file, in the directory. What am I doing incorrectly?
Hi Andreas, trying to implement your fantastic formula on my excel. 2 Quick questions if I may. 1. In terms of the parameters, what is the shortcut symbol for SHARES OUTSTANDING. I can not see that on the list. 2. Also is their a limit to the amount of TICKER symbols I can add. Could I add 500 or so ticker symbols? Love your work. Cheers
Yeh the float is the piece of the pie which is left proceeding the total amount of shares having been created and then swallowed by prior investors. I wonder how we could get the total outstanding shares. Ie the volume of shares which were created at the initial IPO. Thanks
Excellent work. Much obliged for your efforts here. Funny thing is, 10 years ago, I worked for an investment firm and they paid $3k a month for this functionality. Big time kudos to you, Sir.
To be a little more precise, I found that if you're trading NASDAQ, lower case will work just fine. I'm trading mostly Canadian venture and it will only work with Upper case.
Hey mate, thanks for the vid. Was able to get the stock prices working all good. But I was wondering how I'd get something like a currency to work? I am trying to get BTC/USD to work but I'm struggling big time! Your help would be much appreciated. Cheers :)
Hi there, Working perfect! But just a question. Is it complicated to get the information from other sources than Yahoo (borsen.dk)? I'm from denmark, so my excel formulas dosn't work when the numbers are separated by dot and not comma... THANKS AGAIN!
I respond rare to videos.
But here I feel obliged.
WHAT A FANTASTIC, SMART VIDEO, espescially for Mac users to get data from YAHOO FINANCE!
And this without much fuss.
Shame that Steve Jobs probably will not have seen this handsome, useful MAC-work ...
Thank you very much for publishing this video, Andrés.
Great work sir. You have made some difficult programming very easy to follow and duplicate. Looking forward to more videos from you. May force be with you, ALWAYS-->
It runs fine but does not create the quote.txt file...thank you!
I have the same issue, is there another way to generate the quote.txt file?
Thanks very much for taking the time to walk us through this.
Thanks for the video! Works great with EXCEL 2016.
Andres, thanks for sharing. I've been able to make this work following your detailed instructions. Can you please guide me through the steps to add Fx quotes for major currencies. Many thanks.
Thanks! Works like a charm.
Hi Andreas, seems to have got the formula working but I used the LAST PRICE which pertains to the price the security closed at the prior day. Which symbol would I use for real time price (the current price )??. Thank you
Thanks Andreas, the .L work fine with all UK stocks on Google. I can't seem to find the right symbols to download the Dow Jones Industrial nor the FTSE 100. Any ideas? Thanks again for all your advise, it has been really very helpful.
Hey, thank for this great video! Unfortunately, I had some mistakes with the terminal. I wrote everything like you in the terminal and then I saved it. But I cannot find my file I have created - Maybe I didn´t create anyone? Or can you please tell me which sign did you wrote before "curl -o ..." I just made a space?
Thanks Andrés! Very clearly explained tutorial!
I just have another question. How can I put a space between the stocks? Is there a certain symbol for this? I've tried to put a space between 2 commas (AAPL, ,GOOGL). but it didn't work. It is because I have spaces in my excel file.
Kind Regards,
Benoit
Two days ago, the quotes.txt file stopped updating even though the runNow file worked fine and updated every 20 seconds. I remade the runNow executable but it will not create the quote.txt file. Can you please help.Using Excel 15.24 on a new Macbook.
Hi Andreas, I have never programmed anything before but managed to get the stock quotes working perfectly by carefully following your instructions. Many thanks. However, I cannot seem to retrieve any stocks from the UK market (Footsie 100). I can find them on the Google Finance pages (e.g. UK:BP) but cannot find the correct symbol to retrieve them with runNow. Any ideas?
Hi Andreas, UK stock quotes are available on both Google Finance and Yahoo Finance on their web pages. You showed how to retrieve from Google, perhaps I could try from Yahoo if you let me know how to edit Yahoo into runNow.
Thanks for the reply. However can we not program excell to update auto when it is synchronised to the txt file rather than the person having to go through the manual labor.
Know bits and pieces of Excel. Q: Any other way to getting live price updates on Excel? If not, does running the executable file become heavy on the Mac OS?
Is there a way to put in futures/commodities?
Hi Andres, any idea when i run the executable it doesnt make the .txt file
Now Yahoo has stopped the download facility, can we use Google or another stock provider?
Hi, do you know how to get ASX stocks?
Hi Andres, maybe im getting old but it seems millennials are inherently tech-savvy, well done.
My question to you is, how would I obtain parameters for an alternate website? like if I wanted to import hourly search results for say domain.com real estate listings in my area?
Does this not need to be in a csv file?. or a comma delimited CSV as opposed to a txt file. Still struggling with this on my Macbook pro
Their seems to a bug/issue, When the executable file is running and the data has been brought back to the quote.txt file (WHICH IS ACCURATE AND DECIMALISED), when you then import the quotes file into the spreadsheet it does NOT arrive formatted properly.
ie GOOG outstanding shares is 678,365,000 (which is appears correctly in the quotes file. However when I import that data to the excel spreadsheet, Its arrives as only as 678.
Any help would be appreciated. Like wise data from other symbols does the same and thus the whole thing is skewed.
Hi Andres, i download all your files, and when i doubleclick the "runNow" file, windows10 is asking me in wich app i would like to open this file? Can you help please......
I like using MarketXLS. It's great for me.
Looks like a good solution -- any ideas for us poor Windows 8.1 users?
*****
Thanks!
FABULOUS! How could I list all symbols (about 700) in a spreadsheet column and have the program reference the range in order to get the desired information as opposed to typing all the symbols into the program?
***** OK thank you. The Excel script I was using worked that way but I'm not yet savvy enough to figure it out. I'll try though!
***** Here is the Excel Query that worked for years. See if it helps!
WEB
1
moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
Hi Andres, my file is executing without any error. but i am unable to locate the output file. could you please help me?? Please...
Does anyone know the solution for the quote.txt problem? I can get the program to update, but to where? It is not executing the first command to create a text file, in the directory. What am I doing incorrectly?
can you do this on another website? other thah Yahoo finance?
Can i set this up to update when i open excel? If so, how do i do that?
Hi Andreas, trying to implement your fantastic formula on my excel. 2 Quick questions if I may.
1. In terms of the parameters, what is the shortcut symbol for SHARES OUTSTANDING. I can not see that on the list.
2. Also is their a limit to the amount of TICKER symbols I can add. Could I add 500 or so ticker symbols?
Love your work.
Cheers
Yeh the float is the piece of the pie which is left proceeding the total amount of shares having been created and then swallowed by prior investors. I wonder how we could get the total outstanding shares. Ie the volume of shares which were created at the initial IPO.
Thanks
How to use this approach on a Windows? PowerShell has no curl command.
im confused do you need to refresh it manually or is it auto??
Excellent work. Much obliged for your efforts here. Funny thing is, 10 years ago, I worked for an investment firm and they paid $3k a month for this functionality. Big time kudos to you, Sir.
To be a little more precise, I found that if you're trading NASDAQ, lower case will work just fine. I'm trading mostly Canadian venture and it will only work with Upper case.
Hey mate, thanks for the vid. Was able to get the stock prices working all good. But I was wondering how I'd get something like a currency to work? I am trying to get BTC/USD to work but I'm struggling big time! Your help would be much appreciated.
Cheers :)
I use Excel 2013
Stock symbols need to be in all *upper case*. Doesn't work if they are not.
Hi there,
Working perfect! But just a question. Is it complicated to get the information from other sources than Yahoo (borsen.dk)?
I'm from denmark, so my excel formulas dosn't work when the numbers are separated by dot and not comma...
THANKS AGAIN!
Try MarketXLS
If you can pm your email, i can send you a video link of it to show you. Regards