7 Messages
Digest #4546
Messages
Fri May 24, 2019 10:16 am (PDT) . Posted by:
wongkayau
haha, i finally use method 1, changing the selected period and getting data directly from yahoo.
thank you so much for your help. wish you hv a great weekend.
cheers,
L
thank you so much for your help. wish you hv a great weekend.
cheers,
L
Fri May 24, 2019 10:28 am (PDT) . Posted by:
ridgebacksexcel
Randy,
I'm having trouble getting a formula to consistently work to extract P/FFO (FWD) data on Seeking Alpha.
This formula works:
=smfGetTagContent("https://seekingalpha.com/symbol/SKT","span",1,"P/FFO (FWD)")
But this one does not:
=smfGetTagContent("https://seekingalpha.com/symbol/SPG","span",1,"P/FFO (FWD)")
The only change is the ticker and both are REITs. The P/FFO data shows on the webpage on each.
Any ideas?
I'm also looking to get the FFO (TTM): data on the same page but I probably can get that as well if I get the original formula correct.
Thanks.
I'm having trouble getting a formula to consistently work to extract P/FFO (FWD) data on Seeking Alpha.
This formula works:
=smfGetTagContent("https://seekingalpha.com/symbol/SKT","span",1,"P/FFO (FWD)")
But this one does not:
=smfGetTagContent("https://seekingalpha.com/symbol/SPG","
The only change is the ticker and both are REITs. The P/FFO data shows on the webpage on each.
Any ideas?
I'm also looking to get the FFO (TTM): data on the same page but I probably can get that as well if I get the original formula correct.
Thanks.
Fri May 24, 2019 11:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. Both of those formulas work fine here.
BTW, if you use the "pConv" parameter, the formula will convert the
extracted text to a number if it can:
=smfGetTagContent("https://seekingalpha.com/symbol/SKT","span",1,"P/FFO
(FWD)",,,,1)
On Fri, May 24, 2019 at 10:30 AM tmallen2@... wrote:
> I'm having trouble getting a formula to consistently work to extract P/FFO
> (FWD) data on Seeking Alpha.
>
> This formula works:
>
> =smfGetTagContent("https://seekingalpha.com/symbol/SKT","span",1,"P/FFO
> (FWD)")
>
> But this one does not:
>
> =smfGetTagContent("https://seekingalpha.com/symbol/SPG","span",1,"P/FFO
> (FWD)")
>
> The only change is the ticker and both are REITs. The P/FFO data shows on
> the webpage on each.
>
> Any ideas?
>
> I'm also looking to get the FFO (TTM): data on the same page but I
> probably can get that as well if I get the original formula correct.
>
>
>
BTW, if you use the "pConv" parameter, the formula will convert the
extracted text to a number if it can:
=smfGetTagContent("https://seekingalpha.com/symbol/SKT","span",1,"P/FFO
(FWD)",,,,1)
On Fri, May 24, 2019 at 10:30 AM tmallen2@... wrote:
> I'm having trouble getting a formula to consistently work to extract P/FFO
> (FWD) data on Seeking Alpha.
>
> This formula works:
>
> =smfGetTagContent("https://seekingalpha.com/symbol/SKT","span",1,"P/FFO
> (FWD)")
>
> But this one does not:
>
> =smfGetTagContent("https://seekingalpha.com/symbol/SPG","
> (FWD)")
>
> The only change is the ticker and both are REITs. The P/FFO data shows on
> the webpage on each.
>
> Any ideas?
>
> I'm also looking to get the FFO (TTM): data on the same page but I
> probably can get that as well if I get the original formula correct.
>
>
>
Fri May 24, 2019 2:50 pm (PDT) . Posted by:
ridgebacksexcel
It seems to be working now after I tried it again.
The pConv fixed the number recognition problem. Thanks.
The pConv fixed the number recognition problem. Thanks.
Fri May 24, 2019 11:19 am (PDT) . Posted by:
michaelmcintyre2000
Hi Randy et al,
I'm looking to do a percentage change with various look back periods over a (relatively) large universe of tickers. For example, say I wanted to perform a rate of change using current close and close of 20-, 65- 260- periods ago over the S&P500.
Is RCHGetYahooHistory() the only option for this? It would require the function be called 2,000 times to obtain all the data points, which even on an i7 over Ethernet seems to take a while...
Thanks
I'm looking to do a percentage change with various look back periods over a (relatively) large universe of tickers. For example, say I wanted to perform a rate of change using current close and close of 20-, 65- 260- periods ago over the S&P500.
Is RCHGetYahooHistory(
Thanks
Fri May 24, 2019 12:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I use the smfPricesByDates() function to do a limited version that all the
time. There are several templates on the web site. But it would still be
500 Internet calls, one per ticker symbol. I would probably set it up as an
smfUpdateDownloadTable process, so I wouldn't have 500 individual formulas
trying to recalculate all at once. With smfUpdateDownloadTable, values
would be saved in the workbook. Then, if something happens, at least the
ones that complete don't need to be done again.
Your best bet might be a screener or list of the S&P 500. For example you
can get such data in a download file from BarChart:
https://www.barchart.com/stocks/indices/sp/sp500?viewName=62327
When I click on the download button, I get an EXCEL file that begins with:
Symbol Name Last 50D %Chg 50D Chg 1M %Chg 3M %Chg 6M %Chg 9M %Chg 52W %Chg 50D
MA 50D MA Str 50D MA Dir 50D MA 200D Chg
A Agilent Technologies 68.95 -14.48% -11.67 -9.04% -12.09% 1.07% 4.49% 7.52%
Sell Strong Weakest 77.28 1.28
AAL American Airlines Gp 29.12 -9.21% -2.96 -14.18% -17.81% -23.14% -24.86%
-33.03% Sell Strong Strongest 32.72 -9.09
P.S. I was curious to see if the smfUpdateDownloadTable process could be
streamlined to be one Internet call per ticker symbol, so I tried a small
example. I've attached that workbook.
On Fri, May 24, 2019 at 11:19 AM michaelmcintyre2000@... wrote:
> I'm looking to do a percentage change with various look back periods over
> a (relatively) large universe of tickers. For example, say I wanted to
> perform a rate of change using current close and close of 20-, 65- 260-
> periods ago over the S&P500.
>
> Is RCHGetYahooHistory() the only option for this? It would require the
> function be called 2,000 times to obtain all the data points, which even on
> an i7 over Ethernet seems to take a while...
>
>
>
time. There are several templates on the web site. But it would still be
500 Internet calls, one per ticker symbol. I would probably set it up as an
smfUpdateDownloadTable process, so I wouldn't have 500 individual formulas
trying to recalculate all at once. With smfUpdateDownloadTable, values
would be saved in the workbook. Then, if something happens, at least the
ones that complete don't need to be done again.
Your best bet might be a screener or list of the S&P 500. For example you
can get such data in a download file from BarChart:
https://www.barchart.com/stocks/indices/sp/sp500?viewName=62327
When I click on the download button, I get an EXCEL file that begins with:
Symbol Name Last 50D %Chg 50D Chg 1M %Chg 3M %Chg 6M %Chg 9M %Chg 52W %Chg 50D
MA 50D MA Str 50D MA Dir 50D MA 200D Chg
A Agilent Technologies 68.95 -14.48% -11.67 -9.04% -12.09% 1.07% 4.49% 7.52%
Sell Strong Weakest 77.28 1.28
AAL American Airlines Gp 29.12 -9.21% -2.96 -14.18% -17.81% -23.14% -24.86%
-33.03% Sell Strong Strongest 32.72 -9.09
P.S. I was curious to see if the smfUpdateDownloadTa
streamlined to be one Internet call per ticker symbol, so I tried a small
example. I've attached that workbook.
On Fri, May 24, 2019 at 11:19 AM michaelmcintyre2000
> I'm looking to do a percentage change with various look back periods over
> a (relatively) large universe of tickers. For example, say I wanted to
> perform a rate of change using current close and close of 20-, 65- 260-
> periods ago over the S&P500.
>
> Is RCHGetYahooHistory(
> function be called 2,000 times to obtain all the data points, which even on
> an i7 over Ethernet seems to take a while...
>
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)
Fri May 24, 2019 12:49 pm (PDT) . Posted by:
michaelmcintyre2000
Thanks Randy. I really appreciate both the reply and all the support you provide with the tool and on the forum. I'll take a look at what you've suggested.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar