3 New Messages
Digest #2398
Messages
Sun Nov 11, 2012 10:48 am (PST) . Posted by:
"Guest" michaelmcintyre2000
Thanks Randy. That was the issue. Appreciate the help!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/19858
>
> On Sat, Nov 10, 2012 at 6:42 PM, Michael McIntyre <
> michaelmcintyre2000@...> wrote:
>
> >
> > I am unable to successfully download any data from MSN. I am attempting
> > to get the data from the analyst rating page (for example,
> > http://investing.money.msn.com/investments/analyst-ratings?symbol=IBM <http://investing.money.msn.com/investments/analyst-ratings?symbol=MSFT >).
> > I have tried both the SMF-Template-MSN-Analyst-Opinions.xls template, as
> > well as the individual calls (for example, =RCHGetElementNumber("IBM",
> > 362)).
> >
> > I am able to successfully access other sites, so I believe the add-in is
> > correctly installed. No matter what I've tried, the result in the cells
> > always return "Error" even after manually recalculating.
> >
> > Any thoughts?
> >
> >
>
--- In smf_addin@yahoogrou
>
> See: http://finance.
>
> On Sat, Nov 10, 2012 at 6:42 PM, Michael McIntyre <
> michaelmcintyre2000
>
> >
> > I am unable to successfully download any data from MSN. I am attempting
> > to get the data from the analyst rating page (for example,
> > http://investing.
> > I have tried both the SMF-Template-
> > well as the individual calls (for example, =RCHGetElementNumbe
> > 362)).
> >
> > I am able to successfully access other sites, so I believe the add-in is
> > correctly installed. No matter what I've tried, the result in the cells
> > always return "Error" even after manually recalculating.
> >
> > Any thoughts?
> >
> >
>
Mon Nov 12, 2012 2:31 am (PST) . Posted by:
"smithjhhic" smithjhhic
The site recently changed and broke the formula in the previous post.
http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
Due to the recent site changes I was trying to bring back "MFI (14)". For some reason I can't get the formula correct. The value is also in green or red font. Is there a way to bring back that information as well? If it is not possible to display red or green could the value be represented by a (+ or -) or some other method?
I am also trying to obtain the VPT signal for site below with red/green font and having similar difficulty with formula. Any help would be greatly appreciated.
Jeff
http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL&t=apple
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Is this all you want:
>
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",8,">Change",,,,1)
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",5,">Change",,,,1)
>
> On Sun, Oct 7, 2012 at 11:46 AM, smithjhhic <smithjhhic@...> wrote:
>
> > I am not very experienced and having difficulty implementing "bushpilote"
> > suggestion. I am trying to return "14-day SBV" and "14-day Volume MA" for
> > the most recent date. Do I need to bring back the entire table to obtain
> > the data for those two cells for the most recent date? Is there a formula I
> > can enter to obtain just those two cells for a symbol in C3? Any help would
> > be appreciated.
> >
>
http://www.marketvo
Due to the recent site changes I was trying to bring back "MFI (14)". For some reason I can't get the formula correct. The value is also in green or red font. Is there a way to bring back that information as well? If it is not possible to display red or green could the value be represented by a (+ or -) or some other method?
I am also trying to obtain the VPT signal for site below with red/green font and having similar difficulty with formula. Any help would be greatly appreciated.
Jeff
http://www.marketvo
--- In smf_addin@yahoogrou
>
> Is this all you want:
>
> =RCHGetTableCell(
> ",8,">Change"
> =RCHGetTableCell(
> ",5,">Change"
>
> On Sun, Oct 7, 2012 at 11:46 AM, smithjhhic <smithjhhic@
>
> > I am not very experienced and having difficulty implementing "bushpilote"
> > suggestion. I am trying to return "14-day SBV" and "14-day Volume MA" for
> > the most recent date. Do I need to bring back the entire table to obtain
> > the data for those two cells for the most recent date? Is there a formula I
> > can enter to obtain just those two cells for a symbol in C3? Any help would
> > be appreciated.
> >
>
Mon Nov 12, 2012 2:55 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It would just be:
=RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
",6,">Date",,,,1)
=RCHGetTableCell("http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL
",6,">Date",,,,1)
Font shouldn't be an issue for MFI, since it's just based on the value
itself. But, to get the color, you could do something like:
=smfStrExtr(smfGetTagContent("
http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
","tr",1,">Date"),"color:","""")
On Mon, Nov 12, 2012 at 3:31 AM, smithjhhic <smithjhhic@yahoo.com > wrote:
> The site recently changed and broke the formula in the previous post.
>
> http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
>
> Due to the recent site changes I was trying to bring back "MFI (14)". For
> some reason I can't get the formula correct. The value is also in green or
> red font. Is there a way to bring back that information as well? If it is
> not possible to display red or green could the value be represented by a (+
> or -) or some other method?
>
> I am also trying to obtain the VPT signal for site below with red/green
> font and having similar difficulty with formula. Any help would be greatly
> appreciated.
> Jeff
>
> http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL&t=apple
>
=RCHGetTableCell(
",6,">Date",
=RCHGetTableCell(
",6,">Date",
Font shouldn't be an issue for MFI, since it's just based on the value
itself. But, to get the color, you could do something like:
=smfStrExtr(
http://www.marketvo
","tr",1,">Date"
On Mon, Nov 12, 2012 at 3:31 AM, smithjhhic <smithjhhic@yahoo.
> The site recently changed and broke the formula in the previous post.
>
> http://www.marketvo
>
> Due to the recent site changes I was trying to bring back "MFI (14)". For
> some reason I can't get the formula correct. The value is also in green or
> red font. Is there a way to bring back that information as well? If it is
> not possible to display red or green could the value be represented by a (+
> or -) or some other method?
>
> I am also trying to obtain the VPT signal for site below with red/green
> font and having similar difficulty with formula. Any help would be greatly
> appreciated.
> Jeff
>
> http://www.marketvo
>
Tidak ada komentar:
Posting Komentar