Sedang Disiapkan

221827 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:

[url removed, login to view] WMT SLB AAPL&f= nl1vkjm3

[url removed, login to view] - 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 "[url removed, login to view]" or the follow page will appear in your browser.

Kemahiran: AJAX, Semua Boleh, Javascript, Joomla, MySQL, PHP

Lihat lagi: yahoo stock quotes mysql, yahoo-finance, string j, stock ticker javascript, r7 com, q find, mysql db, m string, m3 website, low book sales, l2, javascript stock ticker, import csv into mysql php script, high volume database, dividend com, bid quote, php symbol, m&r sales, g finance, trade finance, trade exchange, stock shares, stock market data, stock exchange, share trade

Tentang Majikan:
( 3 ulasan )

ID Projek: #1968062