3 Messages
Digest #4159
Messages
Thu Sep 28, 2017 12:40 pm (PDT) . Posted by:
nautilustech
Does the fix links macro fix links in the entire workbook or just on the current sheet? Many thanks in advance.
Thu Sep 28, 2017 12:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It should cycle through each worksheet of the active workbook.
On Thu, Sep 28, 2017 at 12:40 PM, nautilustech@
...
wrote:
>
> Does the fix links macro fix links in the entire workbook or just on the
> current sheet? Many thanks in advance.
>
On Thu, Sep 28, 2017 at 12:40 PM, nautilustech@
...
wrote:
>
> Does the fix links macro fix links in the entire workbook or just on the
> current sheet? Many thanks in advance.
>
Thu Sep 28, 2017 4:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
NASDAQ looks easy -- link, headline, time stamp, and source:
="http://www.marketwatch.com"&smfStrExtr(smfGetTagContent($D$2,"p",3*$B4+C$3,"Press
releases on"),"""","""")
=smfGetTagContent($D$2,"p",3*$B4+D$3,"Press releases on",,,,1)
=smfGetTagContent($D$2,"p",3*$B4+E$3,"Press releases on",,,,1)
=smfGetTagContent($D$2,"p",3*$B4+F$3,"Press releases on",,,,1)
...where $D$2 contains the URL. The "3*$B4+F$3" is just a way to create the
table easily, copying down. $B4:$B10 (or whatever) contain 0, 1, 2, ...,
and C$3:F$3 contain 1,1,2,3.
Or another way to look at it is the "3*x+y" increments as 1, 4, 7, ... for
links and headlines, 2, 5, 8, ... for time stamps, and 3, 6, 9, ... for
sources.
So my table ends up looking something like:
http://www.marketwatch.com/investing/stock/BLBD/news
1 1 2 3
0 http://www.marketwatch.com/story/blue-bird-announc… Blue Bird
Announces … 4:03
p.m. Sept. 26, 2017 - BusinessWire - BZX
1 http://www.marketwatch.com/story/earnings-review-a… Earnings Review
and … 7:40
a.m. Aug. 10, 2017 - ACCESSWIRE
2 http://www.marketwatch.com/story/blue-bird-deliver… Blue Bird
Delivers S… 4:00
p.m. Aug. 3, 2017 - BusinessWire - BZX
3 http://www.marketwatch.com/story/investor-network-… Investor
Network: Bl… 11:55
a.m. Aug. 3, 2017 - ACCESSWIRE
You could even combine them into a hyper link table:
http://www.marketwatch.com/investing/stock/BLBD/news
0 Blue Bird Announces Stock Repurchase Agreement with Coliseum Capital
(4:03 p.m. Sept. 26, 2017 - BusinessWire - BZX)
1 Earnings Review and Free Research Report: Fiat's Earnings Rocketed 260%
(7:40 a.m. Aug. 10, 2017 - ACCESSWIRE)
2 Blue Bird Delivers Strong Fiscal 2017 Third Quarter Results; Authorizes
Capital Stock Repurchase Program (4:00 p.m. Aug. 3, 2017 - BusinessWire -
BZX)
3 Investor Network: Blue Bird Corporation to Host Earnings Call (11:55 a.m.
Aug. 3, 2017 - ACCESSWIRE)
...with a formula like:
=HYPERLINK("http://www.marketwatch.com"&smfStrExtr(smfGetTagContent($C$2,"p",3*$B4+1,"Press
releases on"),"""",""""),smfGetTagContent($C$2,"p",3*$B4+1,"Press releases
on",,,,1)&" ("&smfGetTagContent($C$2,"p",3*$B4+2,"Press releases
on",,,,1)&" "&smfGetTagContent($C$2,"p",3*$B4+3,"Press releases
on",,,,1)&")")
...where $C$2 is the URL and $B4:$B7 (or whatever) increments as 0, 1, 2,
...
On Wed, Sep 27, 2017 at 6:24 PM, yolande_tulasse@ wrote:
> I'm trying to get press releases for a specific company from Marketwatch,
> since not all official companies press releases are displayed on Yahoo (see
> the attached screenshot).
>
> However, when I looked at the source code, they unfortunately don't use a
> table tag. They use div tags...
>
> The keywords "Press Release on" brings me right before those div tags I'm
> interested in in the source code, but then how can I extract information
> I need (press release headline + date) from those div tags?
>
> (http://www.marketwatch.com/investing/stock/BLBD/news)
>
> An alternative is the Nasdaq press release page, but they also use div
> tags instead of tables:
>
> http://www.nasdaq.com/symbol/blbd/press-releases
>
>
>
="http://www.marketwatch.com"&smfStrExtr(smfGetTagContent($D$2,"p",3*$B4+C$3,"Press
releases on"),"""","""")
=smfGetTagContent($D$2,"p",3*$B4+D$3,"Press releases on",,,,1)
=smfGetTagContent($D$2,"p",3*$B4+E$3,"Press releases on",,,,1)
=smfGetTagContent($D$2,"p",3*$B4+F$3,"Press releases on",,,,1)
...where $D$2 contains the URL. The "3*$B4+F$3" is just a way to create the
table easily, copying down. $B4:$B10 (or whatever) contain 0, 1, 2, ...,
and C$3:F$3 contain 1,1,2,3.
Or another way to look at it is the "3*x+y" increments as 1, 4, 7, ... for
links and headlines, 2, 5, 8, ... for time stamps, and 3, 6, 9, ... for
sources.
So my table ends up looking something like:
http://www.marketwatch.com/investing/stock/BLBD/news
1 1 2 3
0 http://www.marketwatch.com/story/blue-bird-announc… Blue Bird
Announces … 4:03
p.m. Sept. 26, 2017 - BusinessWire - BZX
1 http://www.marketwatch.com/story/earnings-review-a… Earnings Review
and … 7:40
a.m. Aug. 10, 2017 - ACCESSWIRE
2 http://www.marketwatch.com/story/blue-bird-deliver… Blue Bird
Delivers S… 4:00
p.m. Aug. 3, 2017 - BusinessWire - BZX
3 http://www.marketwatch.com/story/investor-network-… Investor
Network: Bl… 11:55
a.m. Aug. 3, 2017 - ACCESSWIRE
You could even combine them into a hyper link table:
http://www.marketwatch.com/investing/stock/BLBD/news
0 Blue Bird Announces Stock Repurchase Agreement with Coliseum Capital
(4:03 p.m. Sept. 26, 2017 - BusinessWire - BZX)
1 Earnings Review and Free Research Report: Fiat's Earnings Rocketed 260%
(7:40 a.m. Aug. 10, 2017 - ACCESSWIRE)
2 Blue Bird Delivers Strong Fiscal 2017 Third Quarter Results; Authorizes
Capital Stock Repurchase Program (4:00 p.m. Aug. 3, 2017 - BusinessWire -
BZX)
3 Investor Network: Blue Bird Corporation to Host Earnings Call (11:55 a.m.
Aug. 3, 2017 - ACCESSWIRE)
...with a formula like:
=HYPERLINK("http://www.marketwatch.com"&smfStrExtr(smfGetTagContent($C$2,"p",3*$B4+1,"Press
releases on"),"""",""""),smfGetTagContent($C$2,"p",3*$B4+1,"Press releases
on",,,,1)&" ("&smfGetTagContent($C$2,"p",3*$B4+2,"Press releases
on",,,,1)&" "&smfGetTagContent($C$2,"p",3*$B4+3,"Press releases
on",,,,1)&")")
...where $C$2 is the URL and $B4:$B7 (or whatever) increments as 0, 1, 2,
...
On Wed, Sep 27, 2017 at 6:24 PM, yolande_tulasse@ wrote:
> I'm trying to get press releases for a specific company from Marketwatch,
> since not all official companies press releases are displayed on Yahoo (see
> the attached screenshot).
>
> However, when I looked at the source code, they unfortunately don't use a
> table tag. They use div tags...
>
> The keywords "Press Release on" brings me right before those div tags I'm
> interested in in the source code, but then how can I extract information
> I need (press release headline + date) from those div tags?
>
> (http://www.marketwatch.com/investing/stock/BLBD/news)
>
> An alternative is the Nasdaq press release page, but they also use div
> tags instead of tables:
>
> http://www.nasdaq.com/symbol/blbd/press-releases
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar