edit-article
Home
Up
Delete
Article Name:
Article Description:
]
Chapter ID/Name:
Status:
Write
Writing
Written
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center;">yql & yahoo finance</h1> <h2>[WHAT]</h2> <ol> <li>] </li> </ol> <h2>[WHY]</h2> <ol> <li>]</li> <li>] answer forum ? re : pulling data from yahoo finance into my spreadsheet</li> <li>]</li> </ol> <h2>[WHERE]</h2> <ol> <li>]</li> </ol> <h2>[WHEN]</h2> <ol> <li>]</li> </ol> <h2>[EXAMPLE]</h2> <ol> <li>] each user has a 'portfolio' of stocks</li> <li>] each user's portfolio contains different stocks</li> <li>]</li> <li>] every [period], a report spreadsheet that contains 'financial data=__' regarding the users-portfolio, is UPDATED with data from 'src=yahoo finance'</li> <li>]</li> </ol> <h2>[HOW-TO]</h2> <ol> <li>] custom tables - search finance</li> <ol> <li>] 24 tables - yahoo.finance.* - balance sheet, historical-data, industries, ...</li> </ol> <li>] data.csv</li> <ol> <li>] example - pulling csv data from yahoo.finance</li> </ol> <li>] data.html</li> <ol> <li>] example - pulling html div content (finance headlines) from yahoo finance page</li> </ol></ol> <h2>[REFERENCE]</h2> <ol> <li>] yahoo finance api</li> <ol> <li>] <a href="https://developer.yahoo.com/finance/">https://developer.yahoo.com/finance/</a> - Finance offers two dynamic (parameterized) feeds that can be customized based on ticker symbol. The URLs for these feeds take parameters in standard HTTP syntax and return custom RSS output based on those parameters.</li> </ol> <li>] SO q/a - re: pulling data</li> <ol> <li>] terms ? <a href="http://stackoverflow.com/questions/5108399/yahoo-finance-all-currencies-quote-api-documentation" target="_blank">http://stackoverflow.com/questions/5108399/yahoo-finance-all-currencies-quote-api-documentation</a></li> </ol> <li>->] article, tutorial, CODE, example</li> <ol> <li>] <a href="http://www.jarloo.com/get-yahoo-finance-api-data-via-yql/">http://www.jarloo.com/get-yahoo-finance-api-data-via-yql/</a> - ex qry doesnt work, table doesnt exist</li> </ol> <li>] financial data</li> <ol> <li>] current stock price - date</li> <li>] CALC change since last report</li> </ol></ol> <p> </p> <p> </p> <p><strong>] QUERY</strong>'S<br /><br />select * from yahoo.finance.stocks where symbol=”aapl”<br /><br />select * from csv where url='http://download.finance.yahoo.com/d/quotes.csv?s=YHOO,GOOG,AAPL&f=sl1d1t1c1ohgv&e=.csv' and columns='symbol,price,date,time,change,col1,high,low,col2'<br /><br />select * from yahoo.finance.quote where symbol IN ("MSFT","BBRY","GOOG","AAPL")<br />select * from yahoo.finance.quote where symbol in ("YHOO","AAPL","GOOG","MSFT")<br /><br /><br /><strong>] here is a simple example of this type of app</strong><br /><br />- http://sospep.com/view/article?id=35##<br />- I have displayed a 'spreadsheet' on this page with <br />> when you click the "update button" it updates the spreadsheet with "last trade price" and the "current date" which is pulled from the yahoo finance pages<br />> it then recalculates the calculated fields in the spreadsheet using the newly updated pricing and date info<br /><br /><br /><strong>] public</strong><br />http://query.yahooapis.com/v1/public/yql/dons/portfolioOne<br /><br /><strong>] authenticated</strong><br />http://query.yahooapis.com/v1/yql/dons/portfolioOne<br /><br /><br /><strong>] WRITE to google spreadsheet</strong> <br />http://www.programmableweb.com/api/google-spreadsheets<br />https://developers.google.com/google-apps/spreadsheets/ <br />https://developers.google.com/apps-script/guides/sheets#writing<br />https://coderwall.com/p/duapqq<br />http://stackoverflow.com/questions/19887737/pushing-data-to-google-spreadsheet-through-javascript-running-in-browser<br /><br />https://support.google.com/docs/answer/87809?p=forms_welcome&rd=1</p> <p> </p> <ol><ol> <li>]</li> </ol></ol> <h1 style="text-align: center;"> </h1>