7 New Messages
Digest #2518
Messages
Thu Feb 21, 2013 8:39 pm (PST) . Posted by:
"markknutson2005" markknutson2005
Do you have a way to get investors.com's up/down volume ratio from the stock check up page? Or any other page that it may be on for that matter. I checked out the spreadsheet example - "Raw Data for IBD Extract" but it wouldn't work for me. Thanks in advance for any help you can provide.
Thu Feb 21, 2013 8:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Where did you get that file? The only version I can find is in the "Need to
be looked at" folder, which is an obsolete and non-working file. IBD no
longer has things on web pages that use ticker symbols.
Instead, try:
RCHGetTableCell-Template-IBD-Stock-Checkup.xls
I just loaded it up from the files area and it's working fine for me.
On Thu, Feb 21, 2013 at 9:39 PM, markknutson2005 mknu@juno.com> wrote:
> Do you have a way to get investors.com's up/down volume ratio from the
> stock check up page? Or any other page that it may be on for that matter. I
> checked out the spreadsheet example - "Raw Data for IBD Extract" but it
> wouldn't work for me. Thanks in advance for any help you can provide.
>
be looked at" folder, which is an obsolete and non-working file. IBD no
longer has things on web pages that use ticker symbols.
Instead, try:
RCHGetTableCell-
I just loaded it up from the files area and it's working fine for me.
On Thu, Feb 21, 2013 at 9:39 PM, markknutson2005 mknu@juno.com> wrote:
> Do you have a way to get investors.com&#
> stock check up page? Or any other page that it may be on for that matter. I
> checked out the spreadsheet example - "Raw Data for IBD Extract" but it
> wouldn't work for me. Thanks in advance for any help you can provide.
>
Thu Feb 21, 2013 9:24 pm (PST) . Posted by:
"Roger Diaz" rogerdiazbernal
Randy:
How do I know the name of the file?
for example
Income Statements - Quaterly
http://financials.morningstar.com/income-statement/is.html?t=MMM®ion=USA&culture=en-us
Roger
2013/2/21 Roger Diaz rogerdiazb@gmail.com >
> All data downloaed OK
> Thanks Randy, you are great.
>
> Roger
>
How do I know the name of the file?
for example
Income Statements - Quaterly
http://financials.
Roger
2013/2/21 Roger Diaz rogerdiazb@gmail.
> All data downloaed OK
> Thanks Randy, you are great.
>
> Roger
>
Thu Feb 21, 2013 10:01 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I get it by first clicking on the "Export" button on the web page in
FireFox, then going to the menu and choosing
> Tools > Downloads
...and then doing a right click on the file that was just downloaded and
choosing the "Copy Download Link".
Once you've got the necessary URL, you should just be able to change the
ticker symbol and use it for another company... ?
On Thu, Feb 21, 2013 at 10:24 PM, Roger Diaz rogerdiazb@gmail.com > wrote:
>
> How do I know the name of the file?
> for example
> Income Statements - Quaterly
>
> http://financials.morningstar.com/income-statement/is.html?t=MMM®ion=USA&culture=en-us
>
>
FireFox, then going to the menu and choosing
> Tools > Downloads
...and then doing a right click on the file that was just downloaded and
choosing the "Copy Download Link".
Once you've got the necessary URL, you should just be able to change the
ticker symbol and use it for another company... ?
On Thu, Feb 21, 2013 at 10:24 PM, Roger Diaz rogerdiazb@gmail.
>
> How do I know the name of the file?
> for example
> Income Statements - Quaterly
>
> http://financials.
>
>
Fri Feb 22, 2013 3:15 am (PST) . Posted by:
"j14mako" j14mako
Thanks, I'll give that a try.
btw, an unrelated question: when I use RCHGetElementNumber() or RCHGetYahooQuotes(), can I control when it executes and refresh the UDFs? I have many UDF cells in my spreadsheet. Each time when I open the file, it takes a very long time to load all of them. Most of the time, I only need a couple of columns.
Thanks
J.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> As you noted, the problem is that the web page you cite is a dynamically
> generated web page, so there is nothing within the source code of the web
> page for the add-in to extract as data.
>
> The web page the element number uses is an older version of the web page,
> such as:
>
> http://quicktake.morningstar.com/Stock/CashFlowRatios10.asp?Symbol=MMM
>
> I don't see an equivalent page for your company, so they may not be
> available for non-US companies.
>
> However, one workaround would be to grab their CSV file in another
> worksheet, and grab the elements you want from there:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=XASX:HVN ")
>
> Note that that is the file available from the "Export" button on the web
> page you cite. This process may be what the rest of us will have to do when
> the older version of the web page above is finally obsoleted.
>
> On Thu, Feb 21, 2013 at 12:38 PM, j14mako wrote:
>
> >
> > I wanted to get the data for stocks trading on the Australian ASX. For
> > example, I tried to get the 10th year "FCF/Net Income" for HVN.AX using
> > the "ASX:HVN" ticker syntax that Morningstar uses:
> >
> > RCHGetElementNumber("XASX:HVN", 14388)
> >
> > It didn't work. I've tried to encode the ":" as "%3a". No difference.
> >
> > I looked at the URL of Morningstar's webpage. It was:
> >
> >
> > http://financials.morningstar.com/ratios/r.html?t=HVN®ion=AUS&culture=en-us
> >
> > So it required "region=AUS". And the table is loaded dynamically.
> >
> > Is there anything I can do?
> >
>
btw, an unrelated question: when I use RCHGetElementNumber
Thanks
J.
--- In smf_addin@yahoogrou
>
> As you noted, the problem is that the web page you cite is a dynamically
> generated web page, so there is nothing within the source code of the web
> page for the add-in to extract as data.
>
> The web page the element number uses is an older version of the web page,
> such as:
>
> http://quicktake.
>
> I don't see an equivalent page for your company, so they may not be
> available for non-US companies.
>
> However, one workaround would be to grab their CSV file in another
> worksheet, and grab the elements you want from there:
>
> =smfGetCSVFile(
> http://financials.
>
> Note that that is the file available from the "Export" button on the web
> page you cite. This process may be what the rest of us will have to do when
> the older version of the web page above is finally obsoleted.
>
> On Thu, Feb 21, 2013 at 12:38 PM, j14mako wrote:
>
> >
> > I wanted to get the data for stocks trading on the Australian ASX. For
> > example, I tried to get the 10th year "FCF/Net Income" for HVN.AX using
> > the "ASX:HVN" ticker syntax that Morningstar uses:
> >
> > RCHGetElementNumber
> >
> > It didn't work. I've tried to encode the ":" as "%3a"
> >
> > I looked at the URL of Morningstar&#
> >
> >
> > http://financials.
> >
> > So it required "region=
> >
> > Is there anything I can do?
> >
>
Fri Feb 22, 2013 5:10 am (PST) . Posted by:
"Tze Wei," tzewei_79
er....sorry, I'm very new to coding. How do I look at the source code? Is there a code in the group?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> That's because "Sector SPDR" is in the title of the web page, and elsewhere
> before you get to where you want it to be, so you end up getting the first
> table cell after that.
>
> You'll need to do something like:
>
> =RCHGetTableCell("http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol= "&A67,0,">Sector
> SPDR")
>
> ...but then you'll need to parse it out because they have the label and the
> sector in the same table cell.
>
> You do sometimes need to look at the source code of the web page to see how
> things are coded, instead of just guessing what you might need.
>
> On Thu, Feb 21, 2013 at 6:06 AM, Tze Wei, wrote:
>
> >
> > I tried =RCHGetTableCell("
> > http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol= "&A67,1,"Sector
> > SPDR") where A67 = WIN, and the results is "15,693,991Volume"
> >
> > Actually I wanted to capture the sector of a stock now but I can't get
> > this to work. Is there any way to display the Sector SPDR?
> >
>
--- In smf_addin@yahoogrou
>
> That's because "Sector SPDR" is in the title of the web page, and elsewhere
> before you get to where you want it to be, so you end up getting the first
> table cell after that.
>
> You'll need to do something like:
>
> =RCHGetTableCell(
> SPDR")
>
> ...but then you'll need to parse it out because they have the label and the
> sector in the same table cell.
>
> You do sometimes need to look at the source code of the web page to see how
> things are coded, instead of just guessing what you might need.
>
> On Thu, Feb 21, 2013 at 6:06 AM, Tze Wei, wrote:
>
> >
> > I tried =RCHGetTableCell(
> > http://www.sectorsp
> > SPDR") where A67 = WIN, and the results is "15,693,
> >
> > Actually I wanted to capture the sector of a stock now but I can't get
> > this to work. Is there any way to display the Sector SPDR?
> >
>
Fri Feb 22, 2013 6:08 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Thanks, Randy
Perhaps I can make a suggestion to make the "C3" cell a dropdown with the major HTML type.
I know it is a lot to ask, but could you in the future include a worksheet with instructions on how to use the spreadsheet.
Thanks for all you do for us less capable folks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, February 21, 2013 8:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Quick webpage templates
Anything particular in mind?
I finally threw that template together because it was something I did "on the fly" so many times, I decided I may as well make a template out of it and save myself some time. I've used it quite often myself since I created it. But, even creating it "on the fly" only took a few seconds (after "practicing" so many times) -- there really aren't that many moving parts to it.
_,___
Perhaps I can make a suggestion to make the "C3" cell a dropdown with the major HTML type.
I know it is a lot to ask, but could you in the future include a worksheet with instructions on how to use the spreadsheet.
Thanks for all you do for us less capable folks,
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, February 21, 2013 8:45 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Quick webpage templates
Anything particular in mind?
I finally threw that template together because it was something I did "on the fly" so many times, I decided I may as well make a template out of it and save myself some time. I've used it quite often myself since I created it. But, even creating it "on the fly" only took a few seconds (after "practicing&qu
_,___
Tidak ada komentar:
Posting Komentar