8 Messages
Digest #3630
1.2
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
1.3
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
1.6
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
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%)
=$F$3+(($F$2-
it shows
="0.47"
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..
>
>
enter a future date if you like.
=RCHGetYahooHistory
On Mon, Feb 8, 2016 at 1:02 AM, perseuslim11@
>
> i've changed it to this
> =RCHGetYahooHistory
>
> 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%)
>
your values.
On Mon, Feb 8, 2016 at 1:13 AM, perseuslim11@
>
> on the other hand, after using evaluate formula:
>
> =$F$3+(($F$2-
>
> it shows
> ="0.47"
>
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!
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!
>
>
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@
>
> 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)
(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
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:
Posting Komentar