9 Messages
Digest #4258
Messages
Thu Dec 7, 2017 10:22 am (PST) . Posted by:
jozif60637
This is the snapshot of the spreadsheet. As you can see, column K is not populating anything. Any suggestions? Thank you!
Thu Dec 7, 2017 10:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but with all the changes, "C" is now "A" and only gets returned once.
You could change the items from "DOHLCVA" to "DOHLUVC" if you want the
adjusted close in that last column.
On Thu, Dec 7, 2017 at 11:10 AM, jozif60637@
...
wrote:
> This is the snapshot of the spreadsheet. As you can see, column K is not
> populating anything. Any suggestions? Thank you!
>
>
>
You could change the items from "DOHLCVA" to "DOHLUVC" if you want the
adjusted close in that last column.
On Thu, Dec 7, 2017 at 11:10 AM, jozif60637@
...
wrote:
> This is the snapshot of the spreadsheet. As you can see, column K is not
> populating anything. Any suggestions? Thank you!
>
>
>
Thu Dec 7, 2017 10:51 am (PST) . Posted by:
eclipsme
Hi Randy,
Now that I have the add-in working properly and updated to the latest, I am trying to update a worksheet that was built with RCH_Stock_Market_Functions-2.1.2016.09.02.
All cells say 'Error'.
The worksheet should (and did) grab the following data from FinViz. and in this order:
Price, P/E, Forward P/E, Dividend %, PEG, Debt/Eq, Payout Ratio, and change
Here is the formula :
=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($A$2:$A$33,","),1,"?t="&$A2&"&",">"&B$1)
$A$2:$A$33 is a list of tickers.
Any idea why I am getting "Errors"?
Thanks for looking!
Now that I have the add-in working properly and updated to the latest, I am trying to update a worksheet that was built with RCH_Stock_Market_Functions-2.1.2016.09.02.
All cells say 'Error'.
The worksheet should (and did) grab the following data from FinViz. and in this order:
Price, P/E, Forward P/E, Dividend %, PEG, Debt/Eq, Payout Ratio, and change
Here is the formula :
=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin(
$A$2:$A$33 is a list of tickers.
Any idea why I am getting "Errors"
Thanks for looking!
Thu Dec 7, 2017 10:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's because FinViz now uses the "https://" protocol instead of "http://"...
On Thu, Dec 7, 2017 at 11:51 AM, harvey@
...
wrote:
>
> Now that I have the add-in working properly and updated to the latest, I
> am trying to update a worksheet that was built with
> RCH_Stock_Market_Functions-2.1.2016.09.02.
>
> All cells say 'Error'.
>
> The worksheet should (and did) grab the following data from FinViz. and in
> this order:
>
> Price, P/E, Forward P/E, Dividend %, PEG, Debt/Eq, Payout Ratio, and change
>
> Here is the formula :
> =
>
> RCHGetTableCell("http://finviz.com/quote.ashx?t="&
> smfJoin($A$2:$A$33,","),1,"?t="&$A2&"&",">"&B$1)
>
> $A$2:$A$33 is a list of tickers.
>
> Any idea why I am getting "Errors"?
>
> Thanks for looking!
>
On Thu, Dec 7, 2017 at 11:51 AM, harvey@
...
wrote:
>
> Now that I have the add-in working properly and updated to the latest, I
> am trying to update a worksheet that was built with
> RCH_Stock_Market_Functions-2.1.2016.09.02.
>
> All cells say 'Error'.
>
> The worksheet should (and did) grab the following data from FinViz. and in
> this order:
>
> Price, P/E, Forward P/E, Dividend %, PEG, Debt/Eq, Payout Ratio, and change
>
> Here is the formula :
> =
>
> RCHGetTableCell("http://finviz.com/quote.ashx?t="&
> smfJoin($A$2:
>
> $A$2:$A$33 is a list of tickers.
>
> Any idea why I am getting "Errors"
>
> Thanks for looking!
>
Thu Dec 7, 2017 11:50 am (PST) . Posted by:
eclipsme
Yea, that helped! Thanks.
Except now all cells seem to returning the current price for whatever stock is listed in cell A2.
=RCHGetTableCell("https://finviz.com/quote.ashx?t="&smfJoin($A$2:$A$33,","),1,"?t="&$A2&"&",">"&B$1)
It seems like this must be a relative vs absolute reference problem but frankly, I put this together long enough ago that I am not sure how to go about troubleshooting it.
Thanks. You have been a huge help of late with my problems, not to mention the fantastic work that you have done. Thank you for sharing!
Except now all cells seem to returning the current price for whatever stock is listed in cell A2.
=RCHGetTableCell("https://finviz.com/quote.ashx?t="&smfJoin(
It seems like this must be a relative vs absolute reference problem but frankly, I put this together long enough ago that I am not sure how to go about troubleshooting it.
Thanks. You have been a huge help of late with my problems, not to mention the fantastic work that you have done. Thank you for sharing!
Thu Dec 7, 2017 11:55 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Appears to work OK here:
Ticker Price
IBM $153.51
MMM $239.77
On Thu, Dec 7, 2017 at 12:50 PM, harvey@
...
wrote:
>
> Except now all cells seem to returning the current price for whatever
> stock is listed in cell A2.
>
> =RCHGetTableCell("https://finviz.com/quote.ashx?t="&
> smfJoin($A$2:$A$33,","),1,"?t="&$A2&"&",">"&B$1)
>
> It seems like this must be a relative vs absolute reference problem but
> frankly, I put this together long enough ago that I am not sure how to go
> about troubleshooting it.
>
>
Ticker Price
IBM $153.51
MMM $239.77
On Thu, Dec 7, 2017 at 12:50 PM, harvey@
...
wrote:
>
> Except now all cells seem to returning the current price for whatever
> stock is listed in cell A2.
>
> =RCHGetTableCell("https://finviz.com/quote.ashx?t="&
> smfJoin($A$2:
>
> It seems like this must be a relative vs absolute reference problem but
> frankly, I put this together long enough ago that I am not sure how to go
> about troubleshooting it.
>
>
Thu Dec 7, 2017 11:07 am (PST) . Posted by:
"Jose Jacob" pepecan47
I use the following formula to get the M* ranking:
=smfConvertData(smfstrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&$A3,"r_star"),"r_star","'"))&"*"
Is there a way to get the "company name" from the same web page?
Regards, Jose L. Jacob
=smfConvertData(smfstrExtr(RCHGetWebData("http://financials.morningstar.com/company-profile/c.action?t="&$A3,"
Is there a way to get the "company name" from the same web page?
Regards, Jose L. Jacob
Thu Dec 7, 2017 11:41 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Easiest is probably to extract it out of the title of the web page:
=smfStrExtr(smfGetTagContent("
http://financials.morningstar.com/company-profile/c.action?t="&$A3,"title"),":
"," Company Profile")
On Thu, Dec 7, 2017 at 12:07 PM, Jose Jacob pepecan47@
...
wrote:
>
> I use the following formula to get the M* ranking:
>
> =smfConvertData(smfstrExtr(RCHGetWebData("http://
> financials.morningstar.com/company-profile/c.action?t="&$
> A3,"r_star"),"r_star","'"))&"*"
>
> Is there a way to get the "company name" from the same web page?
>
>
=smfStrExtr(smfGetTagContent("
http://financials.morningstar.com/company-profile/c.action?t="&$A3,"
"," Company Profile"
On Thu, Dec 7, 2017 at 12:07 PM, Jose Jacob pepecan47@
...
wrote:
>
> I use the following formula to get the M* ranking:
>
> =smfConvertData(
> financials.mornings
> A3,"r_star&quo
>
> Is there a way to get the "company name" from the same web page?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar