Downloading Yahoo data
|
Algunos métodos para cargar precios de índices o acciones desde Yahoo y copiarlos en Excel ( spreadsheet).-
ATENCIÓN: SU UTILIZACIÓN ES MAS FÁCIL CON FIREFOX QUE CON EXPLORER
http://finance.yahoo.com/d/quotes.csv?s=Lista de índices o stock símbolos separados por “+” &f=Lista de especiales tags
Por ejemplo 1 Indices: Copiar y pegar lo siguiente en la dirección del navegador web: (sin los paréntesis []).
[http://finance.yahoo.com/d/quotes.csv?s=^IPSA+IGPA.SN+^BVSP+^MERV+^DJI+^NYA+^NDX+^IXIC+^GSPC&f=snd1l1]
Ejemplo 2 Acciones Inter10 ADRS: Copiar y pegar lo siguiente en la dirección del navegador web: (sin los paréntesis []).
[http://finance.yahoo.com/d/quotes.csv?s=SQM+AKO-B+BCH+CCU+ENI+EOC+LFL+MAD+SAN+VCO&f=snd1l1]
Lista de especiales Tags :
| a |
Ask |
a2 |
Average Daily Volume |
a5 |
Ask Size |
b |
Bid |
b2 |
Ask (Real-time) |
b3 |
Bid (Real-time) |
b4 |
Book Value |
b6 |
Bid Size |
c |
Change & Percent Change |
c1 |
Change |
c3 |
Commission |
c6 |
Change (Real-time) |
c8 |
After Hours Change (Real-time) |
d |
Dividend/Share |
d1 |
Last Trade Date |
d2 |
Trade Date |
e |
Earnings/Share |
e1 |
Error Indication (returned for symbol changed / invalid) |
e7 |
EPS Estimate Current Year |
e8 |
EPS Estimate Next Year |
e9 |
EPS Estimate Next Quarter |
f6 |
Float Shares |
g |
Day’s Low |
h |
Day’s High |
j |
52-week Low |
k |
52-week High |
g1 |
Holdings Gain Percent |
g3 |
Annualized Gain |
g4 |
Holdings Gain |
g5 |
Holdings Gain Percent (Real-time) |
g6 |
Holdings Gain (Real-time) |
i |
More Info |
i5 |
Order Book (Real-time) |
j1 |
Market Capitalization |
j3 |
Market Cap (Real-time) |
j4 |
EBITDA |
j5 |
Change From 52-week Low |
j6 |
Percent Change From 52-week Low |
k1 |
Last Trade (Real-time) With Time |
k2 |
Change Percent (Real-time) |
k3 |
Last Trade Size |
k4 |
Change From 52-week High |
k5 |
Percebt Change From 52-week High |
l |
Last Trade (With Time) |
l1 |
Last Trade (Price Only) |
l2 |
High Limit |
l3 |
Low Limit |
m |
Day’s Range |
m2 |
Day’s Range (Real-time) |
m3 |
50-day Moving Average |
m4 |
200-day Moving Average |
m5 |
Change From 200-day Moving Average |
m6 |
Percent Change From 200-day Moving Average |
m7 |
Change From 50-day Moving Average |
m8 |
Percent Change From 50-day Moving Average |
n |
Name |
n4 |
Notes |
o |
Open |
p |
Previous Close |
p1 |
Price Paid |
p2 |
Change in Percent |
p5 |
Price/Sales |
p6 |
Price/Book |
q |
Ex-Dividend Date |
r |
P/E Ratio |
r1 |
Dividend Pay Date |
r2 |
P/E Ratio (Real-time) |
r5 |
PEG Ratio |
r6 |
Price/EPS Estimate Current Year |
r7 |
Price/EPS Estimate Next Year |
s |
Symbol |
s1 |
Shares Owned |
s7 |
Short Ratio |
t1 |
Last Trade Time |
t6 |
Trade Links |
t7 |
Ticker Trend |
t8 |
1 yr Target Price |
v |
Volume |
v1 |
Holdings Value |
v7 |
Holdings Value (Real-time) |
w |
52-week Range |
w1 |
Day’s Value Change |
w4 |
Day’s Value Change (Real-time) |
x |
Stock Exchange |
Otros ejemplos:
Ejemplo 3: Copiar y pegar lo siguiente en la dirección del navegador web (sin los paréntesis [])
[http://finance.yahoo.com/d/quotes.csv?s=BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr]
Ejemplo 4: Copiar y pegar lo siguiente en la dirección del navegador web (sin los paréntesis [])
[http://finance.yahoo.com/d/quotes.csv?s=GE&f=nkqwxyr1l9t5p4]
Ejemplo 5:Visitar el siguiente enlace
http://finance.yahoo.com/d/quotes.csv?s=XOM+EK+JNJ+MSFT&f=snd1t1l1ohgvwdyr
|
| Con este enlace se puede BAJAR DIRECTAMENTE A EXCEL los datos históricos del IPSA u otro. |
| http://ichart.yahoo.com/table.csv?s=^IPSA&a=11&b=1&c=1995&d=0&q=31&f=2000> &z=^IPSA&x=.csv |
| BAJAR DATOS HISTORICOS DEL IPSA |
| . |
| . |
| DownloadWebpage_By_Chatarra_V01 |
| Fichero Excel que permite cargar o abrir una pagina Web en Excel y copiar sus datos |
| Ejemplo de pagina y cotizaciones cargados con DownloadWebpage by Chatarra de la Bolsa de Santiago |
 |
| . |
cforms contact form by delicious:days
Otros enlaces: ACCIONES,
BOLSA,
Indice de Precios Consumidor,
INDICES,
IPC,
IPSA,
Schwager
Posts en relación
