3 Messages
Digest #4275
Messages
Tue Dec 26, 2017 12:05 pm (PST) . Posted by:
mff2805
Hello Randy,
i few years ago, you help in making a spreadsheet what downloaded info from this website
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA
is there a way to download the info in a fashion like the new approach to BarChart and Yahoo?
Also, i'd like to be able to get to the individual 4 competitors listed, i.e., pull those names out into 4 separate cells. is there a way to do this?
I'd also like to extract the monthly rating view and the past 3 weeks of ratings. is there a way to do this too.?.
thanks much.
Mike
p.s. still no luck with being able to log in to the IBD website with GetWebData..... gonna cancel subscription that soon.
i few years ago, you help in making a spreadsheet what downloaded info from this website
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA
is there a way to download the info in a fashion like the new approach to BarChart and Yahoo?
Also, i'd like to be able to get to the individual 4 competitors listed, i.e., pull those names out into 4 separate cells. is there a way to do this?
I'd also like to extract the monthly rating view and the past 3 weeks of ratings. is there a way to do this too.?.
thanks much.
Mike
p.s. still no luck with being able to log in to the IBD website with GetWebData..
Tue Dec 26, 2017 1:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't understand the relevance to the "portfolio view" function? The
reason those functions exist is because both Yahoo and Barchart have a way
to list multiple data items for multiple ticker symbols, so it makes sense
to have a function that collects all of that data in a single Internet
request.
I don't see that on the Navellier web site. You can ask for data for a
single ticker symbol. So you would just use something like
RCHGetTableCell() to pull that data from that web page for that ticker
symbol. There's no reason to have a function with multiple ticker symbols,
because the add-in would need to grab an individual web page for each
ticker symbol. The other functions do that anyway.
For the four competitors (vary that third parameter from 1 to 4):
=smfGetTagContent("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA
","a",1,">Competitors")
For the monthly ratings (vary that third parameter from 2 to 13):
=smfStrExtr(smfGetTagContent("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA","td",2,"Monthly
View"),"bar_",".gif")
For the weeklies:
=LEFT(RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA",1,">This
Week:"),1)
=LEFT(RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA",1,">Last
Week:"),1)
=LEFT(RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA",1,">Two
Weeks Ago:"),1)
On Tue, Dec 26, 2017 at 1:05 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> i few years ago, you help in making a spreadsheet what downloaded info
> from this website
> https://navelliergrowth.investorplace.com/portfolio-
> grader/stock-report.html?t=BA
>
> is there a way to download the info in a fashion like the new approach to
> BarChart and Yahoo?
>
> Also, i'd like to be able to get to the individual 4 competitors listed,
> i.e., pull those names out into 4 separate cells. is there a way to do this?
>
> I'd also like to extract the monthly rating view and the past 3 weeks of
> ratings. is there a way to do this too.?.
>
> thanks much.
> Mike
>
> p.s. still no luck with being able to log in to the IBD website with
> GetWebData..... gonna cancel subscription that soon.
>
reason those functions exist is because both Yahoo and Barchart have a way
to list multiple data items for multiple ticker symbols, so it makes sense
to have a function that collects all of that data in a single Internet
request.
I don't see that on the Navellier web site. You can ask for data for a
single ticker symbol. So you would just use something like
RCHGetTableCell() to pull that data from that web page for that ticker
symbol. There's no reason to have a function with multiple ticker symbols,
because the add-in would need to grab an individual web page for each
ticker symbol. The other functions do that anyway.
For the four competitors (vary that third parameter from 1 to 4):
=smfGetTagContent("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA
","a",1,">Competitors")
For the monthly ratings (vary that third parameter from 2 to 13):
=smfStrExtr(smfGetTagContent("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA","td",2,"Monthly
View"),"bar_",".gif")
For the weeklies:
=LEFT(RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA",1,">This
Week:"),1)
=LEFT(RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA",1,">Last
Week:"),1)
=LEFT(RCHGetTableCell("
https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t=BA",1,">Two
Weeks Ago:"),1)
On Tue, Dec 26, 2017 at 1:05 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> i few years ago, you help in making a spreadsheet what downloaded info
> from this website
> https://navelliergrowth.investorplace.com/portfolio-
> grader/stock-
>
> is there a way to download the info in a fashion like the new approach to
> BarChart and Yahoo?
>
> Also, i'd like to be able to get to the individual 4 competitors listed,
> i.e., pull those names out into 4 separate cells. is there a way to do this?
>
> I'd also like to extract the monthly rating view and the past 3 weeks of
> ratings. is there a way to do this too.?.
>
> thanks much.
> Mike
>
> p.s. still no luck with being able to log in to the IBD website with
> GetWebData..
>
Tue Dec 26, 2017 1:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
P.S. Since you were considering the table format of the "portfolio view"
functions, you may want to consider an smfUpdateDownloadTable workbook, to
create a table of **VALUES** from the Navellier web site that you can refer
to. That puts you into control of when you want to recalculate and retrieve
new data. I usually add a "time stamp" column to remind me of when I last
retrieved a row of data.
On Tue, Dec 26, 2017 at 1:05 PM, mff3429@
...
wrote:
>
> i few years ago, you help in making a spreadsheet what downloaded info
> from this website
> https://navelliergrowth.investorplace.com/portfolio-
> grader/stock-report.html?t=BA
>
> is there a way to download the info in a fashion like the new approach to
> BarChart and Yahoo?
>
> Also, i'd like to be able to get to the individual 4 competitors listed,
> i.e., pull those names out into 4 separate cells. is there a way to do this?
>
> I'd also like to extract the monthly rating view and the past 3 weeks of
> ratings. is there a way to do this too.?.
>
>
functions, you may want to consider an smfUpdateDownloadTable workbook, to
create a table of **VALUES** from the Navellier web site that you can refer
to. That puts you into control of when you want to recalculate and retrieve
new data. I usually add a "time stamp" column to remind me of when I last
retrieved a row of data.
On Tue, Dec 26, 2017 at 1:05 PM, mff3429@
...
wrote:
>
> i few years ago, you help in making a spreadsheet what downloaded info
> from this website
> https://navelliergrowth.investorplace.com/portfolio-
> grader/stock-
>
> is there a way to download the info in a fashion like the new approach to
> BarChart and Yahoo?
>
> Also, i'd like to be able to get to the individual 4 competitors listed,
> i.e., pull those names out into 4 separate cells. is there a way to do this?
>
> I'd also like to extract the monthly rating view and the past 3 weeks of
> ratings. is there a way to do this too.?.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar