8 Messages
Digest #3989
Messages
Sat Apr 29, 2017 10:09 pm (PDT) . Posted by:
turley.muller
I would recommend calculating beta your self. The lookback period coupled with the individual observation periods (within the timeframe i.e. - hourly, daily, weekly, monthly prices) could differ significantly. Thus, if one examines a range of samples, running different time ranges to gain of understanding of the stock's behavior and sensitivity to the index; I believe that would be most conducive. Hard to know what the single beta figure reported by financial website entails. Even if they say it's 6 months of daily prices, that period possible could be somewhat of an aberration. However, if you calculate the beta for the last month, then 3 months, 6, 12, and so on ... taking note of the any divergences, and possible reasons for why, using an adjusted beta would be most productive.
You can use the price history function to capture the index and stock data, and employ the capability to vary the observation periods. I have a pretty slick spreadsheet I can share. Taught me that a lot of ETFs (commodity) aren't as efficient as one would initially think
You can use the price history function to capture the index and stock data, and employ the capability to vary the observation periods. I have a pretty slick spreadsheet I can share. Taught me that a lot of ETFs (commodity) aren't as efficient as one would initially think
Sun Apr 30, 2017 8:16 am (PDT) . Posted by:
JD6199
Hello -
Thank you for developing the SMF add-in. I have been using it for years and it is a wonderful resource to do some preliminary screening.
Recently Yahoo changed up their tables and now I am not able to extract the % Insider Purchase.
In order to do this here is what I have been trying, which is not working. It return's an "Error". Here is an example:
1. =RCHGetTableCell($Q4,1,"% Net Shares Purchased (Sold)")
2. Link I am using is https://finance.yahoo.com/quote/GIII/holders?p=GIII https://finance.yahoo.com/quote/GIII/holders?p=GIII
Can you please help me to understand what I may be doing wrong?
Thanks,
Jason
Thank you for developing the SMF add-in. I have been using it for years and it is a wonderful resource to do some preliminary screening.
Recently Yahoo changed up their tables and now I am not able to extract the % Insider Purchase.
In order to do this here is what I have been trying, which is not working. It return's an "Error". Here is an example:
1. =RCHGetTableCell($Q4,1,"% Net Shares Purchased (Sold)")
2. Link I am using is https://finance.yahoo.com/quote/GIII/holders?p=GIII https://finance.yahoo.com/quote/GIII/holders?p=GIII
Can you please help me to understand what I may be doing wrong?
Thanks,
Jason
Sun Apr 30, 2017 8:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
As you noted, Yahoo is changing things. There are no longer tables of data
delivered in the source code of the web page. Instead, they do a JSON call
to get the data and then dynamically build the web page. So the data needs
to be extracted from the JSON data. In this case, from:
https://query1.finance.yahoo.com/v10/finance/quoteSummary/GIII?modules=netSharePurchaseActivity
The most recent add-in release has a new function that does a positional
extraction of data based on a keyword:
=smfGetYahooJSONData("GIII","netSharePurchaseActivity","netPercentInsiderShares")
However, I've since added another function that is more accurate, because
it extracts JSON data based on the fully qualified field name:
=smfGetYahooJSONField("GIII","netSharePurchaseActivity","quoteSummary.result.0.netSharePurchaseActivity.netPercentInsiderShares.raw")
But this function won't be available until the next release of the add-in.
On Sun, Apr 30, 2017 at 7:13 AM, jasondigrande@
...wrote:
> Thank you for developing the SMF add-in. I have been using it for years
> and it is a wonderful resource to do some preliminary screening.
>
> Recently Yahoo changed up their tables and now I am not able to extract
> the % Insider Purchase.
>
> In order to do this here is what I have been trying, which is not working.
> It return's an "Error". Here is an example:
>
> 1. =RCHGetTableCell($Q4,1,"% Net Shares Purchased (Sold)")
>
> 2. Link I am using is *https://finance.yahoo.com/quote/GIII/holders?p=GIII
> <https://finance.yahoo.com/quote/GIII/holders?p=GIII>*
>
> Can you please help me to understand what I may be doing wrong?
>
>
delivered in the source code of the web page. Instead, they do a JSON call
to get the data and then dynamically build the web page. So the data needs
to be extracted from the JSON data. In this case, from:
https://query1.finance.yahoo.com/v10/finance/quoteSummary/GIII?modules=netSharePurchaseActivity
The most recent add-in release has a new function that does a positional
extraction of data based on a keyword:
=smfGetYahooJSONData("GIII","netSharePurchaseActivity","netPercentInsiderShares")
However, I've since added another function that is more accurate, because
it extracts JSON data based on the fully qualified field name:
=smfGetYahooJSONField("GIII","netSharePurchaseActivity","quoteSummary.result.0.netSharePurchaseActivity.netPercentInsiderShares.raw")
But this function won't be available until the next release of the add-in.
On Sun, Apr 30, 2017 at 7:13 AM, jasondigrande@
...wrote:
> Thank you for developing the SMF add-in. I have been using it for years
> and it is a wonderful resource to do some preliminary screening.
>
> Recently Yahoo changed up their tables and now I am not able to extract
> the % Insider Purchase.
>
> In order to do this here is what I have been trying, which is not working.
> It return's an "Error". Here is an example:
>
> 1. =RCHGetTableCell($Q4,1,"% Net Shares Purchased (Sold)")
>
> 2. Link I am using is *https://finance.yahoo.com/quote/GIII/holders?p=GIII
> <https://finance.yahoo.com/quote/GIII/holders?p=GIII>*
>
> Can you please help me to understand what I may be doing wrong?
>
>
Sun Apr 30, 2017 9:47 am (PDT) . Posted by:
gshell422
=smfConvertData(smfGetTagContent("https://finance.yahoo.com/marketupdate/overview","span",-1,"_l84_^dji"))
has stopped working. It now simply returns "Error"
has stopped working. It now simply returns "Error"
Sun Apr 30, 2017 10:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://finance.yahoo.com/quote/
^DJI","span",1,"data-reactid=""190""",,,,1)
On Sun, Apr 30, 2017 at 9:47 AM, gshell422@
...wrote:
>
> =smfConvertData(smfGetTagContent("https://finance.yahoo.com/
> marketupdate/overview","span";,-1,"_l84_^dji"))
>
> has stopped working. It now simply returns "Error"
>
>
=smfGetTagContent("https://finance.yahoo.com/quote/
^DJI","span",1,"data-reactid=""190""",,,,1)
On Sun, Apr 30, 2017 at 9:47 AM, gshell422@
...wrote:
>
> =smfConvertData(smfGetTagContent("https://finance.yahoo.com/
> marketupdate/
>
> has stopped working. It now simply returns "Error"
>
>
Sun Apr 30, 2017 3:14 pm (PDT) . Posted by:
"Jose Jacob" pepecan47
I have been pulling the AAA, AA and A corporate bond yields from Yahoo. Suddenly the formulas stopped working.
=RCHGetTableCell("https://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate Bonds",">20yr AA<")
I cannot even get to the site https://finance.yahoo.com/bonds/composite_bond_rates anymore.
Regards, Jose L. Jacob
=RCHGetTableCell("https://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate Bonds",">20yr AA<")
I cannot even get to the site https://finance.yahoo.com/bonds/composite_bond_rates anymore.
Regards, Jose L. Jacob
Sun Apr 30, 2017 3:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see corporate bond rates elsewhere on Yahoo either...maybe they're
gone for good?
On Sun, Apr 30, 2017 at 3:14 PM, Jose Jacob pepecan47@
...wrote:
>
> I have been pulling the AAA, AA and A corporate bond yields from Yahoo.
> Suddenly the formulas stopped working.
>
> =RCHGetTableCell("https://finance.yahoo.com/bonds/composite_bond_rates
> ",1,">Corporate Bonds",">20yr AA<")
>
> I cannot even get to the site https://finance.yahoo.com/
> bonds/composite_bond_rates anymore.
>
>
gone for good?
On Sun, Apr 30, 2017 at 3:14 PM, Jose Jacob pepecan47@
...wrote:
>
> I have been pulling the AAA, AA and A corporate bond yields from Yahoo.
> Suddenly the formulas stopped working.
>
> =RCHGetTableCell("https://finance.yahoo.com/bonds/composite_bond_rates
> ",1,">Corporate Bonds",">20yr AA<")
>
> I cannot even get to the site https://finance.yahoo.com/
> bonds/composite_
>
>
Sun Apr 30, 2017 5:41 pm (PDT) . Posted by:
"Gaston Bullrich" gbullr
You can get them from FRED.
Here is High Yield for example.
https://fred.stlouisfed.org/series/BAMLH0A0HYM2
For AAA put in AAA in the search box
for BBB BBB
etc.
I don't know what the smf addin is to get stuff out of FRED
On Sun, Apr 30, 2017 at 6:14 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I have been pulling the AAA, AA and A corporate bond yields from Yahoo.
> Suddenly the formulas stopped working.
>
> =RCHGetTableCell("https://finance.yahoo.com/bonds/composite_bond_rates
> ",1,">Corporate Bonds",">20yr AA<")
>
> I cannot even get to the site https://finance.yahoo.com/
> bonds/composite_bond_rates anymore.
>
> Regards,
> Jose L. Jacob
>
>
>
--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907
Here is High Yield for example.
https://fred.stlouisfed.org/series/BAMLH0A0HYM2
For AAA put in AAA in the search box
for BBB BBB
etc.
I don't know what the smf addin is to get stuff out of FRED
On Sun, Apr 30, 2017 at 6:14 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I have been pulling the AAA, AA and A corporate bond yields from Yahoo.
> Suddenly the formulas stopped working.
>
> =RCHGetTableCell("https://finance.yahoo.com/bonds/composite_bond_rates
> ",1,">Corporate Bonds",">20yr AA<")
>
> I cannot even get to the site https://finance.yahoo.com/
> bonds/composite_
>
> Regards,
> Jose L. Jacob
>
>
>
--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar