Selasa, 07 Oktober 2014

[smf_addin] Digest Number 3201

7 Messages

Digest #3201

Messages

Mon Oct 6, 2014 7:59 am (PDT) . Posted by:

ghart21

body{font-family:
Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color:
#ffffff;color: black;}
Thanks Randy

Two quick follow ups;

1/ Where in the documentation should I learn about
RCHGetTableCell() ??

2/How do I reference a cell which contains symbol (such as $B2)
rather than including symbol explicitly (such as VRX) ??

Thanks so much


-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Oct 6, 2014 3:31 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] How to access Yahoo data on
Institutional selling

Just use the RCHGetTableCell() function. For example:

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=VRX",1,">Net
Institutional",">Net Shares Purchased")

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=VRX",1,">Net
Institutional",">% Change")

On Sun, Oct 5, 2014 at 7:57 PM, ghart23@earthlink.net [smf_addin]
<
smf_addin@yahoogroups.com> wrote:

>
> How could I access the net shares purchased (10,888,000) or the
% Change
> for a stock (here VRX)
>
> from the Yahoo Insider transactions page? I used to get this
data from
> MSN It's not one of your standard elements.
>
> Thanks
>
> G Hart
>
> *Net Share Purchase Activity**Insider Purchases* - Last 6
Months Shares
> TransPurchases5,1902Sales6,0001Net Shares Purchased
> (Sold)(810)3Total Insider Shares Held2.97MN/A% Net Shares
Purchased
> (Sold)0%N/A*Net Institutional Purchases* - Prior Qtr to Latest
Qtr SharesNet
> Shares Purchased
> (Sold)(10,888,400)% Change in Institutional Shares
Held(4.42%)Data
> provided by Thomson Financial
>
>
>
>

Mon Oct 6, 2014 11:08 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The documentation of the functions is in the documentation folder on the
web site:

http://ogres-crypt.com/SMF/Documentation/

You just use normal EXCEL concatenation to refer to the ticker symbol in a
cell:

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=" & $B2,1,">Net
Institutional",">Net Shares Purchased")

On Mon, Oct 6, 2014 at 7:59 AM, ghart23@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Two quick follow ups;
>
> 1/ Where in the documentation should I learn about RCHGetTableCell() ??
>
> 2/How do I reference a cell which contains symbol (such as $B2) rather
> than including symbol explicitly (such as VRX) ??
>
>

Mon Oct 6, 2014 11:27 am (PDT) . Posted by:

ghart21

body{font-family:
Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color:
#ffffff;color: black;}
Thanks Randy

I should have thought of concatenate and woken up to the fact
that the argument passed is just like any other string.

George Hart


-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Oct 6, 2014 2:08 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] How to access Yahoo data on
Institutional selling


You just use normal EXCEL concatenation to refer to the ticker
symbol in a
cell:

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=" & $B2,1,">Net
Institutional",">Net Shares Purchased")

Mon Oct 6, 2014 10:58 am (PDT) . Posted by:

hamishthedenizen

You probably already know, but I found 13863 a good substitute

Mon Oct 6, 2014 11:11 pm (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/REAL TIME GOOGLE WITH CHARTOct-07 3 08 48.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : A1-Realtime For 1 to 60 days with chart From Google

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/REAL%20TIME%20GOOGLE%20WITH%20CHARTOct-07%203%2008%2048.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

digsupply <picsound@gmail.com>

Mon Oct 6, 2014 11:59 pm (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/A2-Dividends History.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : A-2-Dividends From Zacks individual Ticker

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/A2-Dividends%20History.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

digsupply <picsound@gmail.com>

Tue Oct 7, 2014 1:02 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/A-4-Candlestick Oct-07 4 04 14.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : A-4 Candlestick Chart With Finviz Data & YahooHistory

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/A-4-Candlestick%20Oct-07%204%2004%2014.xlsm

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

digsupply <picsound@gmail.com>

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.31

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)