219169 Stock Quote mySQL DB import

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.