Senin, 08 Februari 2016

[smf_addin] Digest Number 3630[1 Attachment]

8 Messages

Digest #3630

Messages

Mon Feb 8, 2016 12:13 am (PST) . Posted by:

perseuslim11

on the other hand, after using evaluate formula:

=$F$3+(($F$2-$F$3)*33%)



it shows
="0.47"+(("RM0.92"-"RM0.47")*33%)

Mon Feb 8, 2016 12:18 am (PST) . Posted by:

"Randy Harmelink" rharmelink

No. As I said, you need to either enter no dates or both dates. You can
enter a future date if you like.

=RCHGetYahooHistory("7160.KL",2007,1,1,2099,12,31,"w")

On Mon, Feb 8, 2016 at 1:02 AM, perseuslim11@... wrote:

>
> i've changed it to this
> =RCHGetYahooHistory("&TickerName&",2007,1,1,,,,"w",,,,,)
>
> but i get this
> "something wrong with dates - asked for 2007/1/1 thru 0/0/0
>
> i thought the end dates will default to most recent available date and no
> need enter?
>
> please give me an example? as I've referred to your example in
> documentation but still could get it working hmm..
>
>

Mon Feb 8, 2016 12:19 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Like I said, use the SUBSTITUTE() function to remove the "RM" string from
your values.

On Mon, Feb 8, 2016 at 1:13 AM, perseuslim11@... wrote:

>
> on the other hand, after using evaluate formula:
>
> =$F$3+(($F$2-$F$3)*33%)
>
> it shows
> ="0.47"+(("RM0.92"-"RM0.47")*33%)
>

Mon Feb 8, 2016 12:19 am (PST) . Posted by:

perseuslim11

Randy, I've tried this: =RCHGetYahooHistory(TickerName,2007,1,1,YEAR(TODAY()),TEXT(TODAY(),"MMMM"),MONTH(TODAY()),"w")



but now it returns every cell with
#value!


Mon Feb 8, 2016 12:20 am (PST) . Posted by:

perseuslim11

and i've tried the substitute function, but still it is returning #value!

Mon Feb 8, 2016 12:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Then you're using it wrong. Unless you show me what you're doing, it's hard
to tell what #VALUE! is coming from. Did you use the evaluate formula
process? It should have told you where the error originates.

My patience is wearing thin. Too many of these are simple EXCEL things. You
need to take a class on EXCEL before tackling something like this with the
add-in, which requires advanced concepts.

On Mon, Feb 8, 2016 at 1:20 AM, perseuslim11@... wrote:

>
> and i've tried the substitute function, but still it is returning #value!
>
>

Mon Feb 8, 2016 12:25 am (PST) . Posted by:

perseuslim11

oh, i just noticed i used the substitute formula wrongly, now i got it working ^^ but the yahoo price function i still get this after many corrections n tries @.@


(photo attached)
Attachment(s) from
1 of 1 Photo(s)

Mon Feb 8, 2016 12:32 am (PST) . Posted by:

perseuslim11

i've also tried including quotes on my "TickerName", but also yields the same results.. please see the newly attached photo in the previous msg, thanks!


Sorry for asking so many dumb questions.. :(
I've really tried with trial n error for this yahoo price function
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar