9 Messages
Digest #4495
Messages
Mon Mar 4, 2019 12:46 pm (PST) . Posted by:
friedman_steve
I used to use RCHGetElementNumber($C1,1290) to get the date of most recent earnings released, but it seems like this stopped getting updated. When I run for a big list of stocks, not showing any in the last 10 days.
RUBI is an example that doesn't have most recent, but should.
Is there another formula to grab you could suggest?
I know this site also has..... can you help with formula to grab the top row cell on "Date Reported" column?
Just to clarify, trying to get the date released (like 2/27/19, not the date of the quarter 12/31/18)
Thanks.
RUBI is an example that doesn't have most recent, but should.
Is there another formula to grab you could suggest?
I know this site also has..... can you help with formula to grab the top row cell on "Date Reported" column?
Just to clarify, trying to get the date released (like 2/27/19, not the date of the quarter 12/31/18)
Thanks.
Mon Mar 4, 2019 12:54 pm (PST) . Posted by:
friedman_steve
forgot to add: different site that has data
https://www.nasdaq.com/earnings/report/rubi https://www.nasdaq.com/earnings/report/rubi
Is there another formula to grab you could suggest?
I know this site also has..... can you help with formula to grab the top row cell on "Date Reported" column?
Thanks.
https://www.nasdaq.com/earnings/report/rubi https://www.nasdaq.com/earnings/report/rubi
Is there another formula to grab you could suggest?
I know this site also has..... can you help with formula to grab the top row cell on "Date Reported" column?
Thanks.
Mon Mar 4, 2019 2:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmm. This works fine for me:
=RCHGetElementNumber("RUBI",1290)
It's pulling the data from this web page:
https://www.zacks.com/stock/research/RUBI/earnings-announcements
....which doesn't appear to be updated for the most recent announcement.
To get it from the NASDAQ website:
=smfGetTagContent("https://www.nasdaq.com/earnings/report/rubi
","td",2,">Surprise")
On Mon, Mar 4, 2019 at 1:46 PM friedman_steve@... wrote:
> I used to use RCHGetElementNumber($C1,1290) to get the date of most recent
> earnings released, but it seems like this stopped getting updated. When I
> run for a big list of stocks, not showing any in the last 10 days.
>
> RUBI is an example that doesn't have most recent, but should.
>
> Is there another formula to grab you could suggest?
>
> I know this site also has..... can you help with formula to grab the top
> row cell on "Date Reported" column?
>
> Just to clarify, trying to get the date released (like 2/27/19, not the
> date of the quarter 12/31/18)
>
>
On Mon, Mar 4, 2019 at 1:54 PM friedman_steve@... wrote:
>
> forgot to add: different site that has data
> https://www.nasdaq.com/earnings/report/rubi
> Is there another formula to grab you could suggest?
>
> I know this site also has..... can you help with formula to grab the top
> row cell on "Date Reported" column?
>
>
>
=RCHGetElementNumber("RUBI",1290)
It's pulling the data from this web page:
https://www.zacks.com/stock/research/RUBI/earnings-announcements
....which doesn't appear to be updated for the most recent announcement.
To get it from the NASDAQ website:
=smfGetTagContent("https://www.nasdaq.com/earnings/report/rubi
","td",2,">Surprise")
On Mon, Mar 4, 2019 at 1:46 PM friedman_steve@... wrote:
> I used to use RCHGetElementNumber($C1,1290) to get the date of most recent
> earnings released, but it seems like this stopped getting updated. When I
> run for a big list of stocks, not showing any in the last 10 days.
>
> RUBI is an example that doesn't have most recent, but should.
>
> Is there another formula to grab you could suggest?
>
> I know this site also has..... can you help with formula to grab the top
> row cell on "Date Reported" column?
>
> Just to clarify, trying to get the date released (like 2/27/19, not the
> date of the quarter 12/31/18)
>
>
On Mon, Mar 4, 2019 at 1:54 PM friedman_steve@... wrote:
>
> forgot to add: different site that has data
> https://www.nasdaq.com/earnings/report/rubi
> Is there another formula to grab you could suggest?
>
> I know this site also has..... can you help with formula to grab the top
> row cell on "Date Reported" column?
>
>
>
Tue Mar 5, 2019 7:14 am (PST) . Posted by:
friedman_steve
Awesome. That works. Thanks.
I wish I understood how you create that formula.... would love to learn the trick so don't have to bother you each time.
I wish I understood how you create that formula.... would love to learn the trick so don't have to bother you each time.
Mon Mar 4, 2019 2:49 pm (PST) . Posted by:
sam.leesunwah@yahoo.com
Hi Randy,
Is this function not working ? I have issue on this since March 4th market open in US. Thanks in advance.
Regards,
Sam
Is this function not working ? I have issue on this since March 4th market open in US. Thanks in advance.
Regards,
Sam
Mon Mar 4, 2019 4:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Seems to be working here. Have you tried the template, to see if it works
for you?
Otherwise, Yahoo doesn't always behave well with bad ticker symbols?
On Mon, Mar 4, 2019 at 3:49 PM sam.leesunwah@... wrote:
> Is this function not working ? I have issue on this since March 4th market
> open in US. Thanks in advance.
>
>
>
for you?
Otherwise, Yahoo doesn't always behave well with bad ticker symbols?
On Mon, Mar 4, 2019 at 3:49 PM sam.leesunwah@
> Is this function not working ? I have issue on this since March 4th market
> open in US. Thanks in advance.
>
>
>
Mon Mar 4, 2019 5:07 pm (PST) . Posted by:
sam.leesunwah@yahoo.com
Hi Randy,
I run the followings in VBA and used to work but not now.
test = smfGetYahooPortfolioView("PAYC", "01181920152116", , 1)
Sheets("test").Range("A1:G10") = test
Regards,
Sam
I run the followings in VBA and used to work but not now.
test = smfGetYahooPortfoli
Sheets("
Regards,
Sam
Mon Mar 4, 2019 5:35 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That code works fine here...?
Not sure why you do 10 rows in your range when the function only fills two.
What is not working when the code runs?
On Mon, Mar 4, 2019 at 6:07 PM sam.leesunwah@... wrote:
>
> I run the followings in VBA and used to work but not now.
> test = smfGetYahooPortfolioView("PAYC", "01181920152116", , 1)
>
> Sheets("test").Range("A1:G10") = test
>
>
>
Not sure why you do 10 rows in your range when the function only fills two.
What is not working when the code runs?
On Mon, Mar 4, 2019 at 6:07 PM sam.leesunwah@
>
> I run the followings in VBA and used to work but not now.
> test = smfGetYahooPortfoli
>
> Sheets("
>
>
>
Mon Mar 4, 2019 6:02 pm (PST) . Posted by:
sam.leesunwah@yahoo.com
Hi Randy,
It is my fault to accidentally delete the cookie file that is necessary in mac.
I restore the file and everything works fine.
Thanks
Sam.
BTW, I can retrieve data like the following.
Symbol Open High Low Last Price Volume Last Traded (UNIX) CRM US$165.56 US$165.79 US$155.42 US$158.50 17886304.00 1551733237.00
It is my fault to accidentally delete the cookie file that is necessary in mac.
I restore the file and everything works fine.
Thanks
Sam.
BTW, I can retrieve data like the following.
Symbol Open High Low Last Price Volume Last Traded (UNIX) CRM US$165.56 US$165.79 US$155.42 US$158.50 17886304.00 1551733237.00
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar