4 Messages
Digest #4456
Messages
Mon Jan 7, 2019 9:15 am (PST) . Posted by:
"Fred Wright" fredwwright
I used to be able to get Navellier portfolio grader total grade with
=RCHGetTableCell("https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t="&B2,0,"Total Grade:") == cell B2 contains a valid symbol
but it no longer works.
Anyone else using their data? Below is a screenshot of the page from ie and the source code where I am trying to get the Total Grade: C -- it is the second occurance of "Total Grade:" which may be my problem?
Fred
=RCHGetTableCell("https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t="&B2,0,
but it no longer works.
Anyone else using their data? Below is a screenshot of the page from ie and the source code where I am trying to get the Total Grade: C -- it is the second occurance of "Total Grade:" which may be my problem?
Fred
Attachment(s) from Fred Wright
2 of 2 Photo(s)
Mon Jan 7, 2019 9:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Have you created the security cookie with the IE object with EXCEL (via
keyboard shortcut alt+d+d+w)?
Otherwise, the URL in your image is slightly different than what you have
in your formula.
But, yes, it will try to extract after the first occurrence of the string.
On Mon, Jan 7, 2019 at 10:16 AM Fred Wright fredwwright@... wrote:
>
> I used to be able to get Navellier portfolio grader total grade with
>
> =RCHGetTableCell("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t="&B2,0,"Total
> Grade:") == cell B2 contains a valid symbol
>
> but it no longer works.
>
> Anyone else using their data? Below is a screenshot of the page from ie
> and the source code where I am trying to get the Total Grade: C -- it is
> the second occurance of "Total Grade:" which may be my problem?
>
>
>
keyboard shortcut alt+d+d+w)?
Otherwise, the URL in your image is slightly different than what you have
in your formula.
But, yes, it will try to extract after the first occurrence of the string.
On Mon, Jan 7, 2019 at 10:16 AM Fred Wright fredwwright@... wrote:
>
> I used to be able to get Navellier portfolio grader total grade with
>
> =RCHGetTableCell("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t="&B2,0,
> Grade:"
>
> but it no longer works.
>
> Anyone else using their data? Below is a screenshot of the page from ie
> and the source code where I am trying to get the Total Grade: C -- it is
> the second occurance of "Total Grade:" which may be my problem?
>
>
>
Mon Jan 7, 2019 9:47 am (PST) . Posted by:
"Joe" jtassielli2003
Randy,
I'm using this function in each cell. Don't want to.
I have symbols, b2:r2
I wish to import into one sheet all the data into c1:r91, then use excel functions to grab the data, please advise.
Have you tried the highest rated email app? With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage. For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 1
• Privacy • Unsubscribe • Terms of Use
SPONSORED LINKS .
I'm using this function in each cell. Don't want to.
I have symbols, b2:r2
I wish to import into one sheet all the data into c1:r91, then use excel functions to grab the data, please advise.
Have you tried the highest rated email app? With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage. For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 1
• Privacy • Unsubscribe • Terms of Use
SPONSORED LINKS .
Mon Jan 7, 2019 11:56 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That makes no sense to me. You can't pull data into the range C1:R91,
because that would overlap with almost all of your ticker cell range. And
having your ticker cells ACROSS a row makes it very complicated.
Where are you running into problems with the template and documentation?
Since you have fewer ticker symbols than the template, you could just copy
that worksheet into your own workbook and then put your own values into the
ticker symbols and field codes areas?
Hmm. If I assume you want to have the tickers in cells B2:B91, you could
array-enter something like this function over the C1:R91 range:
=smfGetYahooPortfolioView(B2:B91,"15000000000000000000000000000002",,1)
....changing all the "00" pairs to be your desired field codes.
On Mon, Jan 7, 2019 at 10:56 AM Joe jtassielli2003@... wrote:
>
> I'm using this function in each cell. Don't want to.
>
> I have symbols, b2:r2
>
> I wish to import into one sheet all the data into c1:r91, then use excel
> functions to grab the data, please advise.
>
>
because that would overlap with almost all of your ticker cell range. And
having your ticker cells ACROSS a row makes it very complicated.
Where are you running into problems with the template and documentation?
Since you have fewer ticker symbols than the template, you could just copy
that worksheet into your own workbook and then put your own values into the
ticker symbols and field codes areas?
Hmm. If I assume you want to have the tickers in cells B2:B91, you could
array-enter something like this function over the C1:R91 range:
=smfGetYahooPortfol
....changing all the "00" pairs to be your desired field codes.
On Mon, Jan 7, 2019 at 10:56 AM Joe jtassielli2003@
>
> I'm using this function in each cell. Don't want to.
>
> I have symbols, b2:r2
>
> I wish to import into one sheet all the data into c1:r91, then use excel
> functions to grab the data, please advise.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar