9 New Messages
Digest #2533
Messages
Tue Mar 5, 2013 7:23 am (PST) . Posted by:
"sean" seanlink7
Thanks! What if I wanted to pull from Finviz.com..
Also how do I get the headlines to refresh?
--- In smf_addin@yahoogrou
>
> Only by blanking out those items if you retrieve them...
>
> But nothing proactive that I'm aware of.
>
> On Mon, Mar 4, 2013 at 4:16 PM, sean wrote:
>
> > Thanks!! Any way I can use my own personal Filters for the headlines. IE
> > Have my filter for my yahoo account set to not pick up any Mootley fool
> > articles...Any way that can translate into this add in?
> >
>
Tue Mar 5, 2013 8:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Use smfForceRecalculation to refresh (see entry in LINKS area of Yahoo
group).
As for FinViz, no. You need to examine the source code of the web page to
see how to extract things.
To get time, headline, and link:
=RCHGetTableCell("http://finviz.com/quote.ashx?t=AA
",1,"fullview-news-outer",,,,...row...)
=RCHGetTableCell("http://finviz.com/quote.ashx?t=AA
",2,"fullview-news-outer",,,,...row...)
=smfStrExtr(smfGetTagContent("http://finviz.com/quote.ashx?t=AA
","td",2*...row...,"fullview-news-outer"),"""","""")
On Tue, Mar 5, 2013 at 8:21 AM, sean seanlink7@gmail.com > wrote:
>
> Thanks! What if I wanted to pull from Finviz.com...Say I wanted the first
> news headine from http://finviz.com/quote.ashx?t=AA...is it roughly hte
> same code?
>
> Also how do I get the headlines to refresh?
>
group).
As for FinViz, no. You need to examine the source code of the web page to
see how to extract things.
To get time, headline, and link:
=RCHGetTableCell(
",1,"
=RCHGetTableCell(
",2,"
=smfStrExtr(
","
On Tue, Mar 5, 2013 at 8:21 AM, sean seanlink7@gmail.
>
> Thanks! What if I wanted to pull from Finviz.com..
> news headine from http://finviz.
> same code?
>
> Also how do I get the headlines to refresh?
>
Tue Mar 5, 2013 8:27 am (PST) . Posted by:
"Joel Nybeck" nybeckfinepenco
Tue Mar 5, 2013 3:38 pm (PST) . Posted by:
"tranlehung2008" tranlehung2008
I saw something like 7s Note or 15s Bond somewhere in a book. May you explain to me what the 's' stands for?
Thank you.
Thank you.
Tue Mar 5, 2013 3:38 pm (PST) . Posted by:
"tranlehung2008" tranlehung2008
Is there any difference between Breakup value and Private market value?
Thanks guys.
Thanks guys.
Tue Mar 5, 2013 6:24 pm (PST) . Posted by:
"MoeB" spikemgm
Hi Randy,
Is there a data code list for etfs,
I am using smfgetcsvfile for my etf sheet with codes r pe ratio, d dividend and y dividend yield. I would really like to have the etf expense ratio but there is no code listed.
Etfs on yahoo do not have a Key Statistics page but do have Profile page where expense ratio is listed.
Thanks
Steve
Is there a data code list for etfs,
I am using smfgetcsvfile for my etf sheet with codes r pe ratio, d dividend and y dividend yield. I would really like to have the etf expense ratio but there is no code listed.
Etfs on yahoo do not have a Key Statistics page but do have Profile page where expense ratio is listed.
Thanks
Steve
Tue Mar 5, 2013 9:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not aware of any data codes that are for ETFs only.
On Tue, Mar 5, 2013 at 7:24 PM, MoeB smoebius@gmail.com > wrote:
>
> Is there a data code list for etfs,
>
> I am using smfgetcsvfile for my etf sheet with codes r pe ratio, d
> dividend and y dividend yield. I would really like to have the etf expense
> ratio but there is no code listed.
>
> Etfs on yahoo do not have a Key Statistics page but do have Profile page
> where expense ratio is listed.
>
On Tue, Mar 5, 2013 at 7:24 PM, MoeB smoebius@gmail.
>
> Is there a data code list for etfs,
>
> I am using smfgetcsvfile for my etf sheet with codes r pe ratio, d
> dividend and y dividend yield. I would really like to have the etf expense
> ratio but there is no code listed.
>
> Etfs on yahoo do not have a Key Statistics page but do have Profile page
> where expense ratio is listed.
>
Tue Mar 5, 2013 10:32 pm (PST) . Posted by:
"Stephan Moebius" spikemgm
Thanks,
Then do you know where and how to pull expense ratio numbers.
Steve
On Tue, Mar 5, 2013 at 7:11 PM, Randy Harmelink rharmelink@gmail.com >wrote:
> **
>
>
> I'm not aware of any data codes that are for ETFs only.
>
>
> On Tue, Mar 5, 2013 at 7:24 PM, MoeB smoebius@gmail.com > wrote:
>
>>
>> Is there a data code list for etfs,
>>
>> I am using smfgetcsvfile for my etf sheet with codes r pe ratio, d
>> dividend and y dividend yield. I would really like to have the etf expense
>> ratio but there is no code listed.
>>
>> Etfs on yahoo do not have a Key Statistics page but do have Profile page
>> where expense ratio is listed.
>>
>
>
>
Then do you know where and how to pull expense ratio numbers.
Steve
On Tue, Mar 5, 2013 at 7:11 PM, Randy Harmelink rharmelink@gmail.
> **
>
>
> I'm not aware of any data codes that are for ETFs only.
>
>
> On Tue, Mar 5, 2013 at 7:24 PM, MoeB smoebius@gmail.
>
>>
>> Is there a data code list for etfs,
>>
>> I am using smfgetcsvfile for my etf sheet with codes r pe ratio, d
>> dividend and y dividend yield. I would really like to have the etf expense
>> ratio but there is no code listed.
>>
>> Etfs on yahoo do not have a Key Statistics page but do have Profile page
>> where expense ratio is listed.
>>
>
>
>
Tue Mar 5, 2013 11:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to use the RCHGetTableCell() function. Something like:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY ",1,">Annual Report
Expense Ratio")
However, I think the label varies between different ETFs? And that will be
MUCH slower than the RCHGetYahooQuotes() function.
On Tue, Mar 5, 2013 at 11:32 PM, Stephan Moebius smoebius@gmail.com > wrote:
>
> Then do you know where and how to pull expense ratio numbers.
>
>
=RCHGetTableCell(
Expense Ratio")
However, I think the label varies between different ETFs? And that will be
MUCH slower than the RCHGetYahooQuotes(
On Tue, Mar 5, 2013 at 11:32 PM, Stephan Moebius smoebius@gmail.
>
> Then do you know where and how to pull expense ratio numbers.
>
>
Tidak ada komentar:
Posting Komentar