Selasa, 10 November 2015

[smf_addin] Digest Number 3555

1 Message

Digest #3555
1a
Re: Net Insider Buying/(Selling) by "Randy Harmelink" rharmelink

Message

Mon Nov 9, 2015 8:54 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You aren't doing the concatenations to cell references correctly in the
URL, plus you have the wrong URL if you want to look something up by ticker
symbol. Try:

=RCHGetTableCell("
http://www.j3sg.com/Reports/Stock-Insider/Generate.php?DV=yes&tickerLookUp="&C14,1,">Total
Shares Sold")

You could speed up the calculation tremendously if you do one array-entered
RCHGetYahooQuotes() instead of having one per cell.

On Mon, Nov 9, 2015 at 1:59 AM, scottandrewjackson@... wrote:

>
> Does this insider formula still work? After creating an account, I'm still
> not having any luck. Just trying to find net insider purchases. I don't
> care what the time period is, as long as I know what it is.
>
> Dashboard.xlsx
> <https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0>
> [image: image]
> <https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0>
> Dashboard.xlsx
> <https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0>
> Shared with Dropbox
> View on www.dropbox.com
> <https://www.dropbox.com/s/1l730kcq88z8orp/Dashboard.xlsx?dl=0>
> Preview by Yahoo
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar