4 New Messages
Digest #2319
| |
Messages
Sun Aug 19, 2012 11:35 am (PDT) . Posted by:
"rlee16" rlee16
Randy,
Is there a way to get data from kr.finance.yahoo.com? (KOSPI and KOSDAQ)? Any simple change to the VBA that could do it (Korean stocks have .KS appended to a 6 digit stock number).
Thank you!
Richard
Is there a way to get data from kr.finance.yahoo.
Thank you!
Richard
Sun Aug 19, 2012 12:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why can't you use the .KS suffix with the normal Yahoo website with the
as-is Yahoo functions?
On Sun, Aug 19, 2012 at 11:35 AM, rlee16 <yodimus@gmail.com > wrote:
>
> Is there a way to get data from kr.finance.yahoo.com? (KOSPI and KOSDAQ)?
> Any simple change to the VBA that could do it (Korean stocks have .KS
> appended to a 6 digit stock number).
>
as-is Yahoo functions?
On Sun, Aug 19, 2012 at 11:35 AM, rlee16 <yodimus@gmail.
>
> Is there a way to get data from kr.finance.yahoo.
> Any simple change to the VBA that could do it (Korean stocks have .KS
> appended to a 6 digit stock number).
>
Sun Aug 19, 2012 6:13 pm (PDT) . Posted by:
"Ralph" ralphbag
Randy, would you be so kind as to ( again ) give me the formula to grab
the price of the Mexican Centenario . I have spent over an hour with no
success.
The site from which I want to get this is :
http://www.banamex.com/economia_finanzas/es/divisas_metales/metales.htm
The value at the moment is $23,750.00 under " compra "
Thanks a million .
Ralph
the price of the Mexican Centenario . I have spent over an hour with no
success.
The site from which I want to get this is :
http://www.banamex.
The value at the moment is $23,750.00 under " compra "
Thanks a million .
Ralph
Sun Aug 19, 2012 7:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your problem was probably that the date is presented within an HTML frame
on the page. That means the data is actually at a different URL. This
appears to work:
=RCHGetTableCell("
http://portal.banamex.com.mx/c719_004/divisasMetales/es/metales?xhost=http://www.banamex.com/
",2,">Centenario")
On Sun, Aug 19, 2012 at 6:13 PM, Ralph <ralph.bagwell@gmail.com > wrote:
> Randy, would you be so kind as to ( again ) give me the formula to grab
> the price of the Mexican Centenario . I have spent over an hour with no
> success.
>
> The site from which I want to get this is :
>
> http://www.banamex.com/economia_finanzas/es/divisas_metales/metales.htm
>
> The value at the moment is $23,750.00 under " compra "
>
on the page. That means the data is actually at a different URL. This
appears to work:
=RCHGetTableCell(
http://portal.
",2,">Centenario"
On Sun, Aug 19, 2012 at 6:13 PM, Ralph <ralph.bagwell@
> Randy, would you be so kind as to ( again ) give me the formula to grab
> the price of the Mexican Centenario . I have spent over an hour with no
> success.
>
> The site from which I want to get this is :
>
> http://www.banamex.
>
> The value at the moment is $23,750.00 under " compra "
>
Tidak ada komentar:
Posting Komentar