article

yql & yahoo finance

[WHAT]

1. ] 

[WHY]

1. ]
2. ] answer forum ? re : pulling data from yahoo finance into my spreadsheet
3. ]

[WHERE]

1. ]

[WHEN]

1. ]

[EXAMPLE]

1. ] each user has a 'portfolio' of stocks
2. ] each user's portfolio contains different stocks
3. ]
4. ] every [period], a report spreadsheet that contains 'financial data=__' regarding the users-portfolio, is UPDATED with data from 'src=yahoo finance'
5. ]

[HOW-TO]

1. ] custom tables - search finance
1. ] 24 tables -  yahoo.finance.* - balance sheet,  historical-data, industries, ...
2. ] data.csv
1. ] example - pulling csv data from yahoo.finance
3. ] data.html
1. ] example - pulling html div content (finance headlines) from yahoo finance page

[REFERENCE]

1. ] yahoo finance api
1. ] https://developer.yahoo.com/finance/ -  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.
2. ] SO q/a - re: pulling data
1. ] terms ? http://stackoverflow.com/questions/5108399/yahoo-finance-all-currencies-quote-api-documentation
3. ->] article, tutorial, CODE, example
1. ] http://www.jarloo.com/get-yahoo-finance-api-data-via-yql/ - ex qry doesnt work, table doesnt exist
4. ] financial data
1. ] current stock price - date
2. ] CALC change since last report

 

 

] QUERY'S

select * from yahoo.finance.stocks where symbol=”aapl”

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'

select * from yahoo.finance.quote where symbol IN  ("MSFT","BBRY","GOOG","AAPL")
select * from yahoo.finance.quote where symbol in ("YHOO","AAPL","GOOG","MSFT")


] here is a simple example of this type of app

- http://sospep.com/view/article?id=35##
- I have displayed a 'spreadsheet' on this page with
> 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
> it then recalculates the calculated fields in the spreadsheet using the newly updated pricing and date info


] public
http://query.yahooapis.com/v1/public/yql/dons/portfolioOne

] authenticated
http://query.yahooapis.com/v1/yql/dons/portfolioOne


] WRITE to google spreadsheet
http://www.programmableweb.com/api/google-spreadsheets
https://developers.google.com/google-apps/spreadsheets/
https://developers.google.com/apps-script/guides/sheets#writing
https://coderwall.com/p/duapqq
http://stackoverflow.com/questions/19887737/pushing-data-to-google-spreadsheet-through-javascript-running-in-browser

https://support.google.com/docs/answer/87809?p=forms_welcome&rd=1

 

1. ]

 

Details

ID: 3569

NAME: YQL

DESCRIPTION: ]

AUTHOR: article.author/s

EDITOR: article.editor/s

PUBLISHER: article.publisher/s

STATUS: Write

PRIORITY: 0

OWNER ID: 75

photos

actions

Email Email-Owner SMS and