logo

Ktov yahoo

Share on facebook
Share on twitter

Analyze Financial Data in Excel #01: Connect to web w/ Power Query

9 108 views | 10 Oct. 2016

In the first part of this

In the first part of this series on stock market analysis using the Excel Power BI add-ins, we create a direct connection to Apple's (AAPL) historical stock prices in Yahoo Finance. The connection is created with Power Query. We then upload the data to the Power Pivot data model.

Use the following link to access Apple's historical prices from Yahoo Finance:

http://finance.yahoo.com/quote/AAPL/history?p=AAPL

jazzista1967

i get an error when  I try to download the webpage. I have been looking for a solution like this for almost a year where I can go get the latest exchange rates from Banxico. I will keep trying. Thanks

maxim maxim

This was great, thanks, I've been looking for "api trading software" for a while now, and I think this has helped. Have you heard people talk about - Nonemily Trading Tappify - (do a google search ) ? Ive heard some great things about it and my work buddy got great results with it.

Lotfy Kozman

Thanks for the video, and hope in the future you take us to a different dimension by giving more advanced DAX functions.

chris b

Hey, If you are still around, can you give this a quick run today and see if it still works? I think yahoo! changed something about their download link as excel says it cant '"Authenticate my credentials" under Web Acess. If you or anyone can verify and message me I would appreciate it

Scott x

Nice work, thanks
I hope you add more to the series after #2

Ktov yahoo

Share on facebook
Share on twitter

Ep 228: Markets Pull Back $MCD $DIA $SPY Big Small Cap Winners $SNES $ATOS $DXTR $HTGM $TNDM

883 views | 24 Oct. 2017

Need Penny Stock Training:

Need Penny Stock Training: http://MillionaireTradingAcademy.com

24/7 CHAT ROOM: https://discord.gg/DHp6tRH

FOLLOW ME ON TWITTER @FREESTOCKPICK

Email me: [email protected]

The terms "penny stocks" and "micro-cap stocks" can be used interchangeably. Technically, micro-cap stocks are classified as such based on their market capitalizations, while penny stocks are looked at in terms of their price. Definitions vary, but in general, a stock with a market capitalization between $50 and $300 million is a micro cap. (Less than $50 million is a nano-cap.) According to the Securities & Exchange Commission (SEC), any stock under $5 is a penny stock. Again, definitions can vary; some set the cut-off point at $3, while others consider only those stocks trading at less than $1 to be a penny stock. We consider any stock that is trading on the pink sheets or over-the-counter bulletin board (OTCBB) to be a penny stock.

Mike C

The toilet flush was classy