Rabu, 19 Agustus 2015

[smf_addin] Digest Number 3492

3 Messages

Digest #3492
1a
Re: TMX website by morpheusca8
2b
Re: smfInCellChart Use and Documentation by "Randy Harmelink" rharmelink

Messages

Tue Aug 18, 2015 6:19 pm (PDT) . Posted by:

morpheusca8

you ARE AWESOME........i had tried soooo many things and got sooo frustrated.Thank You!!!

Tue Aug 18, 2015 8:01 pm (PDT) . Posted by:

pdunbar1942

I've just installed SMF Add-In and am trying to display sparkline charts. There are three issues I hope to get pointers on:


The documentation for RCHGetYahooHistory http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooHistory-Function.html lists four "Periods", day, week, month and dividend. I'd like to display an intraday chart in a cell, as Yahoo!Finance displays; is this possible?
Querying stock issues trading less than one year, the function returns a #VALUE error, such as the below example. Is there a way to resolve this and have the chart display the most recently available data? =smfInCellChart(RCHGetYahooHistory("BLD",,,,,,,"d","A",0,,1,365,1)) Minor query: Is there a way to change the default color of the charts?

I'm also looking for documentation on the smfInCellChart function. I've tried running a web search of www.ogres-crypt.com/documentation for the function without finding it. Perhaps I searched the wrong site/path.

Any suggestion is welcome. Thanks

Tue Aug 18, 2015 9:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Tue, Aug 18, 2015 at 7:18 PM, pdunbar1942@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I've just installed SMF Add-In and am trying to display sparkline charts.
> There are three issues I hope to get pointers on:
>
>
> - The documentation for RCHGetYahooHistory
> <http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooHistory-Function.html>
> lists four "Periods", day, week, month and dividend. I'd like to display
> an intraday chart in a cell, as Yahoo!Finance displays; is this possible?
>
>
Not with RCHGetYahooHistory(). Those four periods are the only choices
Yahoo offers for the historical quotes CSV interface.

You'd need to find another source of the data that can feed the vector into
the function.

>
> - Querying stock issues trading less than one year, the function
> returns a #VALUE error, such as the below example. Is there a way to
> resolve this and have the chart display the most recently available data?
> -
> =smfInCellChart(RCHGetYahooHistory("BLD",,,,,,,"d","A",0,,1,365,1))
>
> You could do something like:

=smfInCellChart(RCHGetYahooHistory("BLD",,,,,,,"d","A",0,,1,COUNT(RCHGetYahooHistory("BLD",,,,,,,"d","A",0,,1,365,1)),1))

...but it would be doing two Internet retrievals.

> - Minor query: Is there a way to change the default color of the
> charts?
>
>
The third parameter of the function is for color. The default color is 203.
It's an RGB value.

The second parameter allowed "Line", "Bar", or "Slope", but I think I had
an issue with "Bar" when a lot of points were used. The closest there is to
documentation:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/2818

> I'm also looking for documentation on the smfInCellChart function. I've
> tried running a web search of www.ogres-crypt.com/documentation for the
> function without finding it. Perhaps I searched the wrong site/path.
>

I was never happy with the smfInCellChart() function (or
RCHCreateComment()), so I left it undocumented. The biggest issue was they
both deal with things that don't update normally. If an old shape or image
existed, it had to be cleared. That doesn't happen if the cell content is
deleted. The shapes or comments are left behind.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar