Senin, 08 Februari 2016

[smf_addin] Digest Number 3629[1 Attachment]

15 Messages

Digest #3629

Messages

Sun Feb 7, 2016 6:09 am (PST) . Posted by:

perseuslim11

Hi Randy, I've encountered a problem, like in "Input Tab"
if in cell A1= 52 week high price (using smfgettagcontent)
cell A2= 52 week low price (using smfgettagcontent)


then in another tab, i put cell b2= Input!A1, cell b3=Input!A2


then in cell c3 = b3 + [ (b2-b3)*30% ]
however, i only get #value! for c3


why is it so??
it happened not to this cell only, but also to many other formulas which include cells that gets source data from smf or rch


Please advise?

Sun Feb 7, 2016 10:00 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Without more details, it's hard to diagnose anything.

However, as I recall, your 52-week highs and lows were string text, as they
had "RM" on them. So they would have a #VALUE! result if used in a formula.

On Sun, Feb 7, 2016 at 7:08 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi Randy, I've encountered a problem, like
> in "Input Tab"
> if in cell A1= 52 week high price (using smfgettagcontent)
> cell A2= 52 week low price (using smfgettagcontent)
>
> then in another tab, i put cell b2= Input!A1, cell b3=Input!A2
>
> then in cell c3 = b3 + [ (b2-b3)*30% ]
> however, i only get #value! for c3
>
> why is it so??
> it happened not to this cell only, but also to many other formulas which
> include cells that gets source data from smf or rch
>
> Please advise?
>

Sun Feb 7, 2016 6:00 pm (PST) . Posted by:

perseuslim11

hmm, so is there anyway to make them usable in a formula?

Sun Feb 7, 2016 6:12 pm (PST) . Posted by:

perseuslim11

because the formulas involving the "current price", "52 weel high","52 week low" are all unusable.. hmm.. anyway to convert them into usable form?

Sun Feb 7, 2016 7:11 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You'd need to extract what you want from it. SUBSTITUTION() would probably
be easiest. But not sure if it can be used with data from other sources, if
they're not in the same currency.

On Sun, Feb 7, 2016 at 7:00 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> hmm, so is there anyway to make them usable in a formula?
>
>

Sun Feb 7, 2016 7:31 pm (PST) . Posted by:

perseuslim11

for example value of current price=0.71, 52w high price=0.92, 52w low price=0.47



i would like to get the values 0.71,0.47,0.92




like in my formula=0.47+(0.92-0.47)*33%


i need to get those values to work @.@

Sun Feb 7, 2016 8:19 pm (PST) . Posted by:

perseuslim11

is it possible to get this csv file with the smfgetcsvfile function? I would like to get only the weekly prices data, thanks ^^
I've tried
=smfGetCSVFile("http://finance.yahoo.com/q/hp?s="&TickerNo&".KL&a=06&b=23&c=2003&d=01&e=8&f=2016&g=w")
but it returns nothing...

7160.KL Historical Prices | PENTAMASTER CORPORATION BHD Stock - Yahoo! Finance http://finance.yahoo.com/q/hp?s=7160.KL&a=06&b=23&c=2003&d=01&e=8&f=2016&g=w

7160.KL Historical Prices | PENTAMASTER CORPORATION BHD Stock - Yahoo! Finance http://finance.yahoo.com/q/hp?s=7160.KL&a=06&b=23&c=2003&d=01&e=8&f=2016&g=w Discover historical prices for 7160.KL stock on Yahoo! Finance. View daily, weekly or monthly format back to when PENTAMASTER CORPORATION BHD stock was issued.



View on finance.yahoo.com http://finance.yahoo.com/q/hp?s=7160.KL&a=06&b=23&c=2003&d=01&e=8&f=2016&g=w
Preview by Yahoo







Sun Feb 7, 2016 8:56 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Those values should work fine. If those are the values in the cell, then
use EXCEL's "Evaluate Formula" process to see where the #VALUE! error is
coming from.

On Sun, Feb 7, 2016 at 8:31 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> for example value of current price=0.71, 52w high price=0.92, 52w low
> price=0.47
>
> i would like to get the values 0.71,0.47,0.92
>
> like in my formula=0.47+(0.92-0.47)*33%
>
> i need to get those values to work @.@
>
>

Sun Feb 7, 2016 9:00 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It returns nothing because the URL you're passing is for a web page, not a
CSV file.

Why aren't you just using the RCHGetYahooHistory() function?

On Sun, Feb 7, 2016 at 9:19 PM, perseuslim11@... wrote:

>
> is it possible to get this csv file with the smfgetcsvfile function? I
> would like to get only the weekly prices data, thanks ^^
>
> I've tried
> =smfGetCSVFile("http://finance.yahoo.com/q/hp?s=
> "&TickerNo&".KL&a=06&b=23&c=2003&d=01&e=8&f=2016&g=w")
> but it returns nothing...
>
> 7160.KL Historical Prices | PENTAMASTER CORPORATION BHD Stock - Yahoo!
> Finance
> <http://finance.yahoo.com/q/hp?s=7160.KL&a=06&b=23&c=2003&d=01&e=8&f=2016&g=w>
>

Sun Feb 7, 2016 10:12 pm (PST) . Posted by:

"joo zhi" perseuslim11

Is it possible to get only the weekly price data using the getyahoohistory function?

Sent from Yahoo Mail on Android

On Mon, 8 Feb, 2016 at 2:00, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

Without more details, it's hard to diagnose anything.

However, as I recall, your 52-week highs and lows were string text, as they had "RM" on them. So they would have a #VALUE! result if used in a formula.

On Sun, Feb 7, 2016 at 7:08 AM, perseuslim11@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Hi Randy, I've encountered a problem, likein "Input Tab"
if in cell A1= 52 week high price (using smfgettagcontent)cell A2= 52 week low price (using smfgettagcontent)
then in another tab, i put cell b2= Input!A1, cell b3=Input!A2
then in cell c3 =  b3 + [ (b2-b3)*30% ]however, i only get #value! for c3
why is it so??it happened not to this cell only, but also to many other formulas which include cells that gets source data from smf or rch
Please advise?

Sun Feb 7, 2016 11:12 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It sure is. Yahoo has daily, weekly, and monthly options. Check the
function documentation.

On Sun, Feb 7, 2016 at 11:12 PM, joo zhi perseuslim11@...wrote:

>
> Is it possible to get only the weekly price data using the getyahoohistory
> function?
>
>

Sun Feb 7, 2016 11:52 pm (PST) . Posted by:

perseuslim11

I need Weekly Data from January 2007, so i used formula below


I've used this: =RCHGetYahooHistory(7160,2007, 1, 1,,,,"w",,,,,)



but i only get this: (see photo)


what did I put wrong?
Attachment(s) from
1 of 1 Photo(s)

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

"Randy Harmelink" rharmelink

Either you entered it as text or you have EXCEL configured to show formulas.

But you'll need to specify either no dates or both dates.

Also, you're using an incorrect ticker symbol.

On Mon, Feb 8, 2016 at 12:52 AM, perseuslim11@... wrote:

>
> I need Weekly Data from January 2007, so i used formula below
>
> I've used this:
> =RCHGetYahooHistory(7160,2007, 1, 1,,,,"w",,,,,)
>
> but i only get this: (see photo)
>
> what did I put wrong?
>
>

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

perseuslim11

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..

Sun Feb 7, 2016 6:30 pm (PST) . Posted by:

eadamy

I've been a heavy user of the SMF functions SMFGetYahooHistory and SMFGetYahooQuotes running under Excel 10 on Windows 7. I have no specific issues with the SMF functions; however my very large model (30+ arrays totaling up to 5M cells) has become unstable since moving everything from a Windows 7 laptop to a Windows 10 laptop.

I am evaluating possible Excel upgrade choices including Excel 2013, Excel 2016, and Excel 365 which appears to include Excel 2016 with online collaboration. Because I share the model with another person, the Excel 365 would appear to be ideal; however with SMF applications being critical to my use of Excel, I thought I would check here for other's experience.


Any pointers would be appreciated.


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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)