Selasa, 30 April 2019

[belajar-excel] Digest Number 4760

4 Messages

Digest #4760

Messages

Tue Apr 30, 2019 12:42 am (PDT) . Posted by:

iq_bal76id

Asik ini kek nya.

Kalau besok tanggal 1 gimana?

Sore – malam saya free juga

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>
Sent: Wednesday, April 24, 2019 2:43 PM
To: BeExcel <belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] Click Button di Internet Explorer dengan objectgetElementsByClassName

ayo

kapan mo ke jkt ?

On Wed, Apr 24, 2019 at 10:19 AM Agus nangagus@gmail.com <mailto:nangagus@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

Saya orang udik boleh gak ikut gabung?

On 4/24/2019 08:25, 'Mr. Kid' mr.nmkid@gmail.com <mailto:mr.nmkid@gmail.com> [belajar-excel] wrote:

Ayo kita ngobrolin Excel dimana gitu....

Sabtu Minggu sampai sebelum ramadhan sih ok

Kalau nggak, mungkin mulai akhir juni sabtu minggu juga ok

On Wed, Apr 24, 2019 at 5:44 AM zainul ulum zainul_ulum@yahoo.com <mailto:zainul_ulum@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

mas Kid,

maaf baru bisa replay.

masalahnya solved. Ternyata ada dua buttons dengan classname yang nama dalam page tsb.

Kapan bisa ketemuan langsung? aku banyak kerjaan yang pakai web scrapping....

maturnuwun

_zainul.

On Apr 18, 2019 1:39 AM, "'Mr. Kid' mr.nmkid@gmail.com <mailto:mr.nmkid@gmail.com> [belajar-excel]" <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

mas Zain,

Mungkin tipe datanya dijadikan object malah bisa bekerja... (mungkin loh ya)

Dim oHTML_Element As object

_____

<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/45447;_ylc=X3oDMTJyMWZnbTd0BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTQ0NwRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1NTYwNjkxMzU-?act=reply&messageNum=45447> Reply via web post

•

<mailto:mr.nmkid@gmail.com?subject=Re%3A%20%5Bbelajar-excel%5D%20Click%20Button%20di%20Internet%20Explorer%20dengan%20objectgetElementsByClassName> Reply to sender

•

<mailto:belajar-excel@yahoogroups.com?subject=Re%3A%20%5Bbelajar-excel%5D%20Click%20Button%20di%20Internet%20Explorer%20dengan%20objectgetElementsByClassName> Reply to group

•

<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/newtopic;_ylc=X3oDMTJmcXRtZGhuBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE1NTYwNjkxMzU-> Start a New Topic

•

<https://groups.yahoo..com/neo/groups/belajar-excel/conversations/topics/45428;_ylc=X3oDMTM3OGEwamJvBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTQ0NwRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE1NTYwNjkxMzUEdHBjSWQDNDU0Mjg-> Messages in this topic (4)

_____

<https://s.yimg.com/ru/static/images/yg/img/megaphone/1464031581_phpFA8bON>

<https://yho.com/1wwmgg> Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

_____

...

<http://geo.yahoo.com/serv?s=97359714/grpId=20627678/grpspId=1708298821/msgId=45447/stime=1556069135/nc1=1234567/nc2=2/nc3=3>
<http://y.analytics.yahoo.com/fpc.pl?ywarid=515FB27823A7407E&a=10001310322279&js=no&resp=img&cf12=CP>

Tue Apr 30, 2019 12:57 am (PDT) . Posted by:

"Zainul Ulum" zainul_ulum

be-exceller,sudah lama nih nggak ngobrol excel.kalo sabtu/minggu 4/5 mei 2019 ?
Terimakasih,-zainul

Tue Apr 30, 2019 2:14 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Insya Allah tanggal 1 ok, 4 ok, 5 ok.
Sila diatur saja lokasi dan waktunya.

On Tue, Apr 30, 2019 at 3:09 PM Zainul Ulum zainul_ulum@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> be-exceller,
> sudah lama nih nggak ngobrol excel.
> kalo sabtu/minggu 4/5 mei 2019 ?
>
> Terimakasih,
> -zainul
>
>
>

Tue Apr 30, 2019 10:23 am (PDT) . Posted by:

iq_bal76id

Klo tgl 4 dan 5 saya pulang Surabaya.

Klo lokasi saya yang ndak bisa tentukan neh karena saya bukan orang Jakarta..

1 lagi klo memang ada rencana kopdar sharing session, kantor saya di hari sabtu and minggu bisa di gunakan juga. (bukan untuk tgl 4 dan 5). Klo untuk kapasitas >20 orang bisa lah.

Tinggal materi nya saja.

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>
Sent: Tuesday, April 30, 2019 4:14 PM
To: BeExcel <belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] Click Button di Internet Explorer dengan objectgetElementsByClassName

Insya Allah tanggal 1 ok, 4 ok, 5 ok.

Sila diatur saja lokasi dan waktunya.

On Tue, Apr 30, 2019 at 3:09 PM Zainul Ulum zainul_ulum@yahoo.com <mailto:zainul_ulum@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

be-exceller,

sudah lama nih nggak ngobrol excel.

kalo sabtu/minggu 4/5 mei 2019 ?

Terimakasih,

-zainul

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 22.42 0 komentar

[smf_addin] Digest Number 4531

5 Messages

Digest #4531
1a
Re: Source for Option Quotes & Other data by "Randy Harmelink" rharmelink
1c
Re: Source for Option Quotes & Other data by "Randy Harmelink" rharmelink
2a
Marketgrader by nelsonmuntz1000
2b
Re: Marketgrader by "Randy Harmelink" rharmelink

Messages

Mon Apr 29, 2019 8:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's not something I look at. Best bet would be to take a scan through the
element definition list.

I know the Yahoo Key Statistic page has something called "Leveraged Free
Cash Flow".

On Mon, Apr 29, 2019 at 5:26 AM alberto.ratti@... wrote:

>
> Could you list some items of the "various sources" (regardless the
> "definition" of Free Cash Flow we are interested in)?
>
> Just to let us deepen – on our own choice – the Free Cash Flow issue.
>
>
>

Mon Apr 29, 2019 8:57 am (PDT) . Posted by:

alberto.ratti

RANDY,
Thanks, once more, for your kindness.
I have followed your advice and the reach - for my purpose - was the
SMF-Template-Morningstar-Key-Ratios.xls template.
On the bottom:
Description
Element Definition
Operating Cash Flow Growth (YOY)
14354
Free Cash Flow Growth (YOY)
14365
Cap Ex as a % of Sales
14376
Free Cash Flow/Sales
14387
Free Cash Flow/Net Income
14398

For the first two items (element #14354, #14365) I get "0.0%", all the time, whatever ticker I enter.
Is it ok?

Mon Apr 29, 2019 10:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It looks like MorningStar isn't populating those two items:

https://quicktake.morningstar.com/stocknet/CashFlowRatios10.aspx?Symbol=MMM

Aside from that, I'm not sure how well they are updating those quicktake
pages...?

On Mon, Apr 29, 2019 at 9:09 AM alberto.ratti@... wrote:

>
> I have followed your advice and the reach - for my purpose - was the
>
> *SMF-Template-Morningstar-Key-Ratios.xls* template.
>
> On the bottom:
>
> *Description*
>
> *Element Definition*
>
> *Operating Cash Flow Growth (YOY)*
>
> 14354
>
> *Free Cash Flow Growth (YOY)*
>
> 14365
>
> *Cap Ex as a % of Sales *
>
> 14376
>
> *Free Cash Flow/Sales *
>
> 14387
>
> *Free Cash Flow/Net Income *
>
> 14398
>
>
>
> For the first two items (element #14354, #14365) I get "0.0%", all the
> time, whatever ticker I enter.
>
> Is it ok?
>
>
>

Mon Apr 29, 2019 8:19 pm (PDT) . Posted by:

nelsonmuntz1000

Hi Randy


Hope all is well


Your solution from Aug 2015 looked like it stopped accessing Marketgrader today. Direct link for a selected ticker looks like it takes you to a generic intro page and the add-in formula stopped extracting data. Looks like things may have changed.


Just a heads up.
29051Re: [smf_addin] MarketGrader Scores
Expand Messages


Randy Harmelink
Aug 26, 2015



It's no longer in a "div" tag. Try:

=smfConvertData(smfGetTagContent("http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol= http://www.marketgrader.com/MG.Services/BOL/OnePage.jsp?symbol="&A1,"b",1,">Rating"))


To fix it, I had to look at the source code of the web page to see how it was coded.







Tue Apr 30, 2019 12:58 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. There's nothing there for the add-in to extract. I don't even see
ticker specific options for data.

On Mon, Apr 29, 2019 at 8:19 PM ccoupe300@.... wrote:

> Your solution from Aug 2015 looked like it stopped accessing Marketgrader
> today. Direct link for a selected ticker looks like it takes you to a
> generic intro page and the add-in formula stopped extracting data. Looks
> like things may have changed.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.42 0 komentar

Senin, 29 April 2019

[smf_addin] Digest Number 4530

3 Messages

Digest #4530

Messages

Sun Apr 28, 2019 11:59 am (PDT) . Posted by:

e_bartsch

Hello all:


With all the changes that happens, it looks like we need a subscription to a data service to get key data to import into Excel.


Any recommendations where I can go (free or pay) to get this data:


Stock Name (based on ticker) Bid Price based on Option Ticker Ask Price based on Option Ticker Morningstar Buy Price (Element 887) Chart Replacement (for RCHGetComment (SYMB,1) Last Qtr Free Cash Flow

Thanks.


Eric

Sun Apr 28, 2019 3:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The first three items can be gotten with the smfGetYahooPortfolioView()
function. It can be array-entered to get the data for multiple tickers with
one Internet request. Very quick.

The Morningstar item requires a subscription.

The chart item still works.

Free Cash Flow is available from various sources, but it would depend on
whose definition of it you wanted to use.

On Sun, Apr 28, 2019 at 11:59 AM eabartsch@... wrote:

>
> With all the changes that happens, it looks like we need a subscription to
> a data service to get key data to import into Excel.
>
> Any recommendations where I can go (free or pay) to get this data:
>
> Stock Name (based on ticker)
> Bid Price based on Option Ticker
> Ask Price based on Option Ticker
> Morningstar Buy Price (Element 887)
> Chart Replacement (for RCHGetComment (SYMB,1)
> Last Qtr Free Cash Flow
>

Mon Apr 29, 2019 5:24 am (PDT) . Posted by:

alberto.ratti

RANDY,
Could you list some items of the "various sources" (regardless the "definition" of Free Cash Flow we are interested in)?
Just to let us deepen – on our own choice – the Free Cash Flow issue.
Thanks a lot!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.42 0 komentar
Langganan: Postingan (Atom)