5 New Messages
Digest #2486
Messages
Tue Jan 29, 2013 3:02 am (PST) . Posted by:
"navelhunt" navelhunt
Hi Randy,
Am stuck trying to extract table data from the following link which is used within morningstar.
http://insiders.morningstar.com/trading/insider-activity-data2.action?t=AVEO®ion=USA&culture=en-us&pagesize=100
So i can use smfgettagcontent with 4 find criteria, but this is not unique enough as any of the row/column data in that table repeats sometimes, and then the extraction doesnt flow through the page.
So i tried rchgettablecell, however, i somehow cant seem to find a way to go to the next row in this table.
Wonder if you had any thoughts around how to jump to the next row on this sort of layout.
Thanks
Am stuck trying to extract table data from the following link which is used within morningstar.
http://insiders.
So i can use smfgettagcontent with 4 find criteria, but this is not unique enough as any of the row/column data in that table repeats sometimes, and then the extraction doesnt flow through the page.
So i tried rchgettablecell, however, i somehow cant seem to find a way to go to the next row in this table.
Wonder if you had any thoughts around how to jump to the next row on this sort of layout.
Thanks
Tue Jan 29, 2013 7:01 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the documentation for the function -- there is a parameter for
skipping rows.
On Tue, Jan 29, 2013 at 4:02 AM, navelhunt navelhunt@yahoo.com > wrote:
> Hi Randy,
> Am stuck trying to extract table data from the following link which is
> used within morningstar.
>
>
> http://insiders.morningstar.com/trading/insider-activity-data2.action?t=AVEO®ion=USA&culture=en-us&pagesize=100
>
> So i can use smfgettagcontent with 4 find criteria, but this is not unique
> enough as any of the row/column data in that table repeats sometimes, and
> then the extraction doesnt flow through the page.
>
> So i tried rchgettablecell, however, i somehow cant seem to find a way to
> go to the next row in this table.
>
> Wonder if you had any thoughts around how to jump to the next row on this
> sort of layout.
>
skipping rows.
On Tue, Jan 29, 2013 at 4:02 AM, navelhunt navelhunt@yahoo.
> Hi Randy,
> Am stuck trying to extract table data from the following link which is
> used within morningstar.
>
>
> http://insiders.
>
> So i can use smfgettagcontent with 4 find criteria, but this is not unique
> enough as any of the row/column data in that table repeats sometimes, and
> then the extraction doesnt flow through the page.
>
> So i tried rchgettablecell, however, i somehow cant seem to find a way to
> go to the next row in this table.
>
> Wonder if you had any thoughts around how to jump to the next row on this
> sort of layout.
>
Tue Jan 29, 2013 4:09 am (PST) . Posted by:
"cesarcrivelli" cesarcrivelli
Hello everyone
I know that this may be a little off topic, but i need some help and you may be able too provide me some color
In the past two weeks I have been looking for Brazilian stock market data, and Yahoo proved to be an unreliable source of it. Just to put an example on the table, when retrieving the closing price for some of the most important names (PETR4.sa, BRFS3.sa, VALE5.sa, IGTA3.sa) in Bovespa (Brazilian Stock Exchange) for some names it stops at 23/Jan, for others 17/Jan, so definetly it is a mess...
The most reliable source of info that I found is Reuters.com, Bloomberg.com and 4-traders.com, which were very helpful in the work I am doing, but the problem with them is that is not possible to retreive past data, for example, 1 year of closing price, they just allow to get the info that is on their web page, not historic.
I was wondering if somebody in this group works with is kind of data (Brazilian stock market) and can help me.
Another thing is related to peers comparison. Does anyone know a website, or source of data, that provides a table with peers? Again... related to brazil.
Randy, many thanks for the help in the past weeks, and sorry for this off topic post.
Best,
I know that this may be a little off topic, but i need some help and you may be able too provide me some color
In the past two weeks I have been looking for Brazilian stock market data, and Yahoo proved to be an unreliable source of it. Just to put an example on the table, when retrieving the closing price for some of the most important names (PETR4.sa, BRFS3.sa, VALE5.sa, IGTA3.sa) in Bovespa (Brazilian Stock Exchange) for some names it stops at 23/Jan, for others 17/Jan, so definetly it is a mess...
The most reliable source of info that I found is Reuters.com, Bloomberg.com and 4-traders.com, which were very helpful in the work I am doing, but the problem with them is that is not possible to retreive past data, for example, 1 year of closing price, they just allow to get the info that is on their web page, not historic.
I was wondering if somebody in this group works with is kind of data (Brazilian stock market) and can help me.
Another thing is related to peers comparison. Does anyone know a website, or source of data, that provides a table with peers? Again... related to brazil.
Randy, many thanks for the help in the past weeks, and sorry for this off topic post.
Best,
Tue Jan 29, 2013 6:57 am (PST) . Posted by:
"Alain Bigio" albibr
Dear Randy,
I am new comer in this group. I am a brazilian user of the function
YF_PRICE() that requires the YF Quote addin. The only difference with the
US NYSE is that I have to concatenate ".SA" at the end of the symbol to
indicate I am looking into the brazilian stock market
I would like to use your function if possible could you please let me know
where I can download the addin and how do I introduce the RCHGetYahooQuotes()
in my spreadsheet
thank you very much
--
Alain
alain@bigio.net.br
I am new comer in this group. I am a brazilian user of the function
YF_PRICE() that requires the YF Quote addin. The only difference with the
US NYSE is that I have to concatenate ".SA" at the end of the symbol to
indicate I am looking into the brazilian stock market
I would like to use your function if possible could you please let me know
where I can download the addin and how do I introduce the RCHGetYahooQuotes(
in my spreadsheet
thank you very much
--
Alain
alain@bigio.
Tue Jan 29, 2013 7:00 am (PST) . Posted by:
"Randy Harmelink" rharmelink
This information was in the "Welcome to the group" message that was sent to
you when you joined:
"The first step to using the add-in would be to visit the files area of the
group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. Installation instructions and documentation of the
various functions can be found in the "Documentation" folder. Sample uses
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."
On Tue, Jan 29, 2013 at 5:11 AM, Alain Bigio alain@bigio.net.br > wrote:
>
> I am new comer in this group. I am a brazilian user of the function
> YF_PRICE() that requires the YF Quote addin. The only difference with the
> US NYSE is that I have to concatenate ".SA" at the end of the symbol to
> indicate I am looking into the brazilian stock market
>
> I would like to use your function if possible could you please let me know
> where I can download the addin and how do I introduce the RCHGetYahooQuotes()
> in my spreadsheet
>
>
you when you joined:
"The first step to using the add-in would be to visit the files area of the
group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. Installation instructions and documentation of the
various functions can be found in the "Documentation
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."
On Tue, Jan 29, 2013 at 5:11 AM, Alain Bigio alain@bigio.
>
> I am new comer in this group. I am a brazilian user of the function
> YF_PRICE() that requires the YF Quote addin. The only difference with the
> US NYSE is that I have to concatenate ".SA" at the end of the symbol to
> indicate I am looking into the brazilian stock market
>
> I would like to use your function if possible could you please let me know
> where I can download the addin and how do I introduce the RCHGetYahooQuotes(
> in my spreadsheet
>
>
Tidak ada komentar:
Posting Komentar