Looking for someone to build a stock database and website for joomla from yahoo finance. The mySQL DB should run a script updating the DB with 1 years data backtrack. The DB should also compute RSI, Stochastics and MACD. The 1st phase will be for only 50 ETF symbols.
Parameters needed:
parameters provided by Yahoo Finance.
a Ask k5 % Change from 52-W
a2 Average Daily Volume l Last Trade with Time
a5 Ask Size l1 Last Trade (Price Only)
b Bid l2 High Limit
b2 Ask (RT) l3 Low Limit
b3 Bid (RT) m Day's Range
b4 Book Value m2 Day's Range (RT)
b6 Bid Size m3 50-Day MA
c % Change m4 200-D MA
c1 Change m5 Change from 200-D MA
c3 Commission m6 % Change from 200-D MA
c6 Change (RT) m7 Change from 50-D MA
c8 After Hour Change (RT) m8 % Change from 50-D MA
d Dividend/Sahre n Name
d1 Last Trade Date n4 Notes
d2 Trade Date o Open
e Earning/Share p Previous Close
e1 Error Indication p1 Price Paid
e7 EPS Estimate Current Year p2 Change in %
e8 EPS Estimate Next Year p5 Price/Sales
e9 EPS Estimate Next Quarter p6 Price/Book
f6 Float Shares q Ex-Dividend Date
g Day's Low r P/E Ratio
h Day's High r1 Dividend Pay Date
j 52-Week Low r2 P/E Ratio (RT)
k 52-Week High r5 PEG Ratio
g1 Holding Gain % r6 Price/EPS Estimate Current Year
g3 Annualized Gain r7 Price/EPS Estimate Next Year
g4 Holding Gain s Symbol
g5 Holding Gain % (RT) s1 Shares Owned
g6 Holding Gain (RT) s7 Short Ratio
i More Info t1 Last Trade Time
i5 Order Book (RT) t6 Trade Links
j1 Market Capitalization t7 Ticker Trend
j3 Market Cap (RT) t8 1 Year Target
j4 EBITDA v Volume
j5 Cahnge from 52-W Low v1 Holding Value
j6 % Change from 52-W Low v7 Holding Value (RT)
k1 Last Trade with Time (RT) w 52-W Range
k2 Change % (RT) w1 Day's Value Change
k3 Last Trade Size w4 Day's Value Change(RT)
k4 Change from 52-W High x Stock Exchange
y dividend Yeild
Let's say that you have the following quotes in your portfolioCAT, WMT, SLB, AAPLYou want to get the Name, Last Price, Last Traded Volume, 52-Week High, 52-Week Low and 50-Day MA.
From the table above, we can find out that the parameters needed are as follow:
Name - n
Last Price- l1
Last Traded Volume - v
52-Week High - k
52-Week Low - j
50-Day MA - m3
All you need to do is to construct the URL with the given parameters above.
The URL will looks like this:
[login to view URL] WMT SLB AAPL&f= nl1vkjm3
[login to view URL] - The default URL to get the information
's=' - Append your stocks information after this
& - to join the string
'f=' - Append the URL parameters after this with no spaces in between
Depends on you Internet browser setting, You maybe asked to save the results into a filename call "[login to view URL]" or the follow page will appear in your browser.