6 New Messages
Digest #2605
Messages
Sun May 5, 2013 9:21 am (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
I have a problem with RCHGetTableCell with my local (domestic) financial sites. The problem is basically in number format. US format goes like this 123,456.15, but in Eastern Europe numbers are formatted like this 123.456,15.
I am trying to fetch stock price from this link http://www.belex.rs/trgovanje/hartija/dnevni/DJMN
Translation for the word price is "Cena" and for that company (link above) is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for separator)so the rch function works as it should, but when there is separator(for that number stated above) instead of twenty five thousands... (25,120) I get 25.12 (twenty five point twelve).
=RCHGetTableCell("http://www.belex.rs/trgovanje/hartija/dnevni/DJMN ",1,"Cena")
I've tried to change separator setting manually or with VBA, but that only works if I am using VBA to fetch bulk data (from web option) with Excel. RCH function is immune to separator changes.
Please help.
Thanks.
I am trying to fetch stock price from this link http://www.belex.
Translation for the word price is "Cena" and for that company (link above) is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for separator)so the rch function works as it should, but when there is separator(for that number stated above) instead of twenty five thousands... (25,120) I get 25.12 (twenty five point twelve).
=RCHGetTableCell(
I've tried to change separator setting manually or with VBA, but that only works if I am using VBA to fetch bulk data (from web option) with Excel. RCH function is immune to separator changes.
Please help.
Thanks.
Sun May 5, 2013 10:42 am (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
I have a problem with RCHGetTableCell with my local (domestic) financial sites. The problem is basically in number format. US format goes like this 123,456.15, but in Eastern Europe numbers are formatted like this 123.456,15.
I am trying to fetch stock price from this link http://www.belex.rs/trgovanje/hartija/dnevni/DJMN
Translation for the word price is "Cena" and for that company (link above) is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for separator)so the rch function works as it should, but when there is separator(for that number stated above) instead of twenty five thousands... (25,120) I get 25.12 (twenty five point twelve).
=RCHGetTableCell("http://www.belex.rs/trgovanje/hartija/dnevni/DJMN ",1,"Cena")
I've tried to change separator setting manually or with VBA, but that only works if I am using VBA to fetch bulk data (from web option) with Excel. RCH function is immune to separator changes.
Please help.
Thanks.
I am trying to fetch stock price from this link http://www.belex.
Translation for the word price is "Cena" and for that company (link above) is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for separator)so the rch function works as it should, but when there is separator(for that number stated above) instead of twenty five thousands... (25,120) I get 25.12 (twenty five point twelve).
=RCHGetTableCell(
I've tried to change separator setting manually or with VBA, but that only works if I am using VBA to fetch bulk data (from web option) with Excel. RCH function is immune to separator changes.
Please help.
Thanks.
Sun May 5, 2013 2:14 pm (PDT) . Posted by:
"Marco Deen" marco.deen
The easiest workaround is to change the region on your computer to U.S.
Control Panel > Region and Language > Formats
On Sun, May 5, 2013 at 12:20 PM, Jovica Bozic <jovica.bozic@yahoo.com >wrote:
> **
>
>
> I have a problem with RCHGetTableCell with my local (domestic) financial
> sites. The problem is basically in number format. US format goes like this
> 123,456.15, but in Eastern Europe numbers are formatted like this
> 123.456,15.
>
> I am trying to fetch stock price from this link
> http://www.belex.rs/trgovanje/hartija/dnevni/DJMN
> Translation for the word price is "Cena" and for that company (link above)
> is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for
> separator)so the rch function works as it should, but when there is
> separator(for that number stated above) instead of twenty five thousands...
> (25,120) I get 25.12 (twenty five point twelve).
> =RCHGetTableCell("http://www.belex.rs/trgovanje/hartija/dnevni/DJMN
> ",1,"Cena")
>
> I've tried to change separator setting manually or with VBA, but that only
> works if I am using VBA to fetch bulk data (from web option) with Excel.
> RCH function is immune to separator changes.
>
> Please help.
> Thanks.
>
>
>
Control Panel > Region and Language > Formats
On Sun, May 5, 2013 at 12:20 PM, Jovica Bozic <jovica.bozic@
> **
>
>
> I have a problem with RCHGetTableCell with my local (domestic) financial
> sites. The problem is basically in number format. US format goes like this
> 123,456.15, but in Eastern Europe numbers are formatted like this
> 123.456,15.
>
> I am trying to fetch stock price from this link
> http://www.belex.
> Translation for the word price is "Cena" and for that company (link above)
> is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for
> separator)so the rch function works as it should, but when there is
> separator(for that number stated above) instead of twenty five thousands...
> (25,120) I get 25.12 (twenty five point twelve).
> =RCHGetTableCell(
> ",1,"
>
> I've tried to change separator setting manually or with VBA, but that only
> works if I am using VBA to fetch bulk data (from web option) with Excel.
> RCH function is immune to separator changes.
>
> Please help.
> Thanks.
>
>
>
Mon May 6, 2013 12:17 am (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
That doesn't work with RCH functions. Instead 2.45 I would get 2,45 and not 2,450.
--- In smf_addin@yahoogroups.com , Marco Deen <marco.deen@...> wrote:
>
> The easiest workaround is to change the region on your computer to U.S.
> Control Panel > Region and Language > Formats
>
>
> On Sun, May 5, 2013 at 12:20 PM, Jovica Bozic <jovica.bozic@...>wrote:
>
> > **
> >
> >
> > I have a problem with RCHGetTableCell with my local (domestic) financial
> > sites. The problem is basically in number format. US format goes like this
> > 123,456.15, but in Eastern Europe numbers are formatted like this
> > 123.456,15.
> >
> > I am trying to fetch stock price from this link
> > http://www.belex.rs/trgovanje/hartija/dnevni/DJMN
> > Translation for the word price is "Cena" and for that company (link above)
> > is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for
> > separator)so the rch function works as it should, but when there is
> > separator(for that number stated above) instead of twenty five thousands...
> > (25,120) I get 25.12 (twenty five point twelve).
> > =RCHGetTableCell("http://www.belex.rs/trgovanje/hartija/dnevni/DJMN
> > ",1,"Cena")
> >
> > I've tried to change separator setting manually or with VBA, but that only
> > works if I am using VBA to fetch bulk data (from web option) with Excel.
> > RCH function is immune to separator changes.
> >
> > Please help.
> > Thanks.
> >
> >
> >
>
--- In smf_addin@yahoogrou
>
> The easiest workaround is to change the region on your computer to U.S.
> Control Panel > Region and Language > Formats
>
>
> On Sun, May 5, 2013 at 12:20 PM, Jovica Bozic <jovica.bozic@
>
> > **
> >
> >
> > I have a problem with RCHGetTableCell with my local (domestic) financial
> > sites. The problem is basically in number format. US format goes like this
> > 123,456.15, but in Eastern Europe numbers are formatted like this
> > 123.456,15.
> >
> > I am trying to fetch stock price from this link
> > http://www.belex.
> > Translation for the word price is "Cena" and for that company (link above)
> > is 25,120 (or 25.120). If the price is below 1,000 (so there is no need for
> > separator)so the rch function works as it should, but when there is
> > separator(for that number stated above) instead of twenty five thousands...
> > (25,120) I get 25.12 (twenty five point twelve).
> > =RCHGetTableCell(
> > ",1,"
> >
> > I've tried to change separator setting manually or with VBA, but that only
> > works if I am using VBA to fetch bulk data (from web option) with Excel.
> > RCH function is immune to separator changes.
> >
> > Please help.
> > Thanks.
> >
> >
> >
>
Sun May 5, 2013 6:32 pm (PDT) . Posted by:
"scott_mastbrook" scott_mastbrook
Randy,
I'm having trouble with this function. I tried entering the two statements below and am just getting "Error" in the cell. Per the directions, I have logged into the site on Internet Explorer, but still get "Error". How do I get this function to work?
Thanks,
Scott
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Actually, those two formulas don't even need the 2nd and 3rd parameters.
> They can just be:
>
> =smfGet888OptionQuote("QQQ",,,,"HV10L")
> =smfGet888OptionQuote("QQQ",,,,"HV10LD")
>
> On Mon, Jan 28, 2013 at 10:58 AM, Randy Harmelink <rharmelink@...>wrote:
>
> > Another possibility -- if you are using version 2.1.2012.12.29 of the
> > add-in, tell me whether these works for you:
> >
> > =smfGet888OptionQuote("QQQ","C","2/16/2013",,"HV10L")
> > =smfGet888OptionQuote("QQQ","C","2/16/2013",,"HV10LD")
> >
> > If not, visit this web page with IE or the EXCEL Web Query dialog:
> >
> > http://oic.ivolatility.com/oic_adv_options.j?exp_date=-1&ticker=QQQ
> >
> > ...and then run smfForceRecalculation and try again.
> >
> > Let me know what happens.
> >
> > If that does work, you can find documentation for that function in the
> > "Works in Progress" folder of the files area.
> >
>
I'm having trouble with this function. I tried entering the two statements below and am just getting "Error" in the cell. Per the directions, I have logged into the site on Internet Explorer, but still get "Error"
Thanks,
Scott
--- In smf_addin@yahoogrou
>
> Actually, those two formulas don't even need the 2nd and 3rd parameters.
> They can just be:
>
> =smfGet888OptionQuo
> =smfGet888OptionQuo
>
> On Mon, Jan 28, 2013 at 10:58 AM, Randy Harmelink <rharmelink@
>
> > Another possibility -- if you are using version 2.1.2012.12.
> > add-in, tell me whether these works for you:
> >
> > =smfGet888OptionQuo
> > =smfGet888OptionQuo
> >
> > If not, visit this web page with IE or the EXCEL Web Query dialog:
> >
> > http://oic.ivolatil
> >
> > ...and then run smfForceRecalculati
> >
> > Let me know what happens.
> >
> > If that does work, you can find documentation for that function in the
> > "Works in Progress" folder of the files area.
> >
>
Sun May 5, 2013 6:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. I just tried both after getting an SPY quotes page first, and they
worked fine for me.
Try getting a quote page on SPY with the EXCEL Web Query process instead of
with IE. Then do an smfForceRecalculation to get a new copy of the web page
its extracting data from.
However, I will note I have had issues with them from time to time.
On Sun, May 5, 2013 at 6:32 PM, scott_mastbrook
<scott_mastbrook@yahoo.com >wrote:
> Randy,
> I'm having trouble with this function. I tried entering the two
> statements below and am just getting "Error" in the cell. Per the
> directions, I have logged into the site on Internet Explorer, but still get
> "Error". How do I get this function to work?
>
> Thanks,
> Scott
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Actually, those two formulas don't even need the 2nd and 3rd parameters.
> > They can just be:
> >
> > =smfGet888OptionQuote("QQQ",,,,"HV10L")
> > =smfGet888OptionQuote("QQQ",,,,"HV10LD")
>
worked fine for me.
Try getting a quote page on SPY with the EXCEL Web Query process instead of
with IE. Then do an smfForceRecalculati
its extracting data from.
However, I will note I have had issues with them from time to time.
On Sun, May 5, 2013 at 6:32 PM, scott_mastbrook
<scott_mastbrook@
> Randy,
> I'm having trouble with this function. I tried entering the two
> statements below and am just getting "Error" in the cell. Per the
> directions, I have logged into the site on Internet Explorer, but still get
> "Error"
>
> Thanks,
> Scott
>
> --- In smf_addin@yahoogrou
> >
> > Actually, those two formulas don't even need the 2nd and 3rd parameters.
> > They can just be:
> >
> > =smfGet888OptionQuo
> > =smfGet888OptionQuo
>
Tidak ada komentar:
Posting Komentar