10 New Messages
Digest #2775
Messages
Mon Sep 16, 2013 5:00 am (PDT) . Posted by:
boonemdph
Hi
in Belgium and in some other countries the notification of
numbers is different: we use the comma for decimals and the dot
for the thousands. This gives wrong data when using the macros.
I added 2 lines in the macro smfConvertData to solve my problem.
For those who have the same problem, here the change: (last 2
lines)
Public Function smfConvertData(
Optional ByVal pConv As Integer = 0)
'-------
------------
' 2011.02.16 -- Add routine
' 2012.01.21 -- Trim data coming in to function
' 2012.04.07 -- Add "Bill" and "Mill" suffixes conversions
'-------
------------
s1 = Trim(pData)
On Error GoTo ErrorExit
If InStr(s1, "/"
Else
If s1 = "-" Then s1 = "0"
If s1 = "--" Then s1 = "0"
If s1 = "---" Then s1 = "0"
If s1 = Chr(150) Then s1 = "0"
If Left(s1, 1) = "$" Then s1 = Mid(s1, 2)
If Left(s1, 1) = "(" And Right(s1, 1) = ")" Then s1 = "-"
& Mid(s1, 2, Len(s1) - 2)
s2 = s1
s2 = Replace(s1, ","
s2 = Replace(s1, "."
Select Case True
regards
Marc
Mon Sep 16, 2013 6:39 am (PDT) . Posted by:
"Bey Melamed" BEYMELAMED
It would be much better to have the code sensitive to regional settings.
Just a thought
---------------------------------------------------------- CONFIDENTIALITY NOTICE: This communication is confidential, may be privileged and is meant only for the intended recipient. If you are not the intended recipient, you may not disclose, copy or use it. Please notify the sender ASAP and delete any copies from your system You should protect your system from viruses etc.; we accept no responsibility for damage that may be caused by them. ----------------------------------------------------------
Just a thought
------------
Mon Sep 16, 2013 8:52 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
--- In smf_addin@yahoogrou
>
> Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It works. But it is very slow. A spreadsheer which retrieve the option chain for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion on how to speed it up?
> tx
>
Mon Sep 16, 2013 8:54 am (PDT) . Posted by:
"john.kalkanis" john.kalkanis
I use smfGetOptionQuotes to get ask, bid, last, close, strike, expiry, underlying price from OX.
Are you saying sources would be faster than OX? which ones?
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I can't say if that's normal or not. I usually only get one or two option
> chains. But it would depend on which functions you're using and which data
> source you're using. For example, I use OptionsXPress even though it's
> slow, because it has much more reliable data.
>
> It does sound high though.
>
> On Thu, Sep 12, 2013 at 11:11 AM, john.kalkanis <john.kalkanis@...>wrote:
>
> > Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It
> > works. But it is very slow. A spreadsheer which retrieve the option chain
> > for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion
> > on how to speed it up?
> >
>
Are you saying sources would be faster than OX? which ones?
--- In smf_addin@yahoogrou
>
> I can't say if that's normal or not. I usually only get one or two option
> chains. But it would depend on which functions you're using and which data
> source you're using. For example, I use OptionsXPress even though it's
> slow, because it has much more reliable data.
>
> It does sound high though.
>
> On Thu, Sep 12, 2013 at 11:11 AM, john.kalkanis <john.kalkanis@
>
> > Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It
> > works. But it is very slow. A spreadsheer which retrieve the option chain
> > for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion
> > on how to speed it up?
> >
>
Mon Sep 16, 2013 8:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo and Google are faster, but they often have missing strikes and/or
expiration dates.
On Mon, Sep 16, 2013 at 8:54 AM, john.kalkanis <john.kalkanis@yahoo.com>wrote:
> I use smfGetOptionQuotes to get ask, bid, last, close, strike, expiry,
> underlying price from OX.
> Are you saying sources would be faster than OX? which ones?
>
expiration dates.
On Mon, Sep 16, 2013 at 8:54 AM, john.kalkanis <john.kalkanis@
> I use smfGetOptionQuotes to get ask, bid, last, close, strike, expiry,
> underlying price from OX.
> Are you saying sources would be faster than OX? which ones?
>
Mon Sep 16, 2013 3:27 pm (PDT) . Posted by:
"john.kalkanis" john.kalkanis
I am using smfGetOptionQuotes to retrieve ask, bid, last, close, strike, expiration, underlying price from OX...
Are you saying other sources are faster than OX? which one?
Do you have other suggestions on how to speed it up?
thanks
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I can't say if that's normal or not. I usually only get one or two option
> chains. But it would depend on which functions you're using and which data
> source you're using. For example, I use OptionsXPress even though it's
> slow, because it has much more reliable data.
>
> It does sound high though.
>
> On Thu, Sep 12, 2013 at 11:11 AM, john.kalkanis <john.kalkanis@...>wrote:
>
> > Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It
> > works. But it is very slow. A spreadsheer which retrieve the option chain
> > for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion
> > on how to speed it up?
> >
>
Are you saying other sources are faster than OX? which one?
Do you have other suggestions on how to speed it up?
thanks
--- In smf_addin@yahoogrou
>
> I can't say if that's normal or not. I usually only get one or two option
> chains. But it would depend on which functions you're using and which data
> source you're using. For example, I use OptionsXPress even though it's
> slow, because it has much more reliable data.
>
> It does sound high though.
>
> On Thu, Sep 12, 2013 at 11:11 AM, john.kalkanis <john.kalkanis@
>
> > Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It
> > works. But it is very slow. A spreadsheer which retrieve the option chain
> > for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion
> > on how to speed it up?
> >
>
Mon Sep 16, 2013 11:55 am (PDT) . Posted by:
boothman11
It works just fine for Apple 2015 options, but just shows "error"
for the 2016 Apple options. Am I doing something wrong? Where
are the option quotes pulled from? Perhaps that site is not
showing option prices that far out.
for the 2016 Apple options. Am I doing something wrong? Where
are the option quotes pulled from? Perhaps that site is not
showing option prices that far out.
Mon Sep 16, 2013 5:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Without the specifics of the parameters you're using, I have nothing to
look at.
On Mon, Sep 16, 2013 at 11:55 AM, <jbooth11@gmail.com> wrote:
>
> It works just fine for Apple 2015 options, but just shows "error" for the
> 2016 Apple options. Am I doing something wrong? Where are the option
> quotes pulled from? Perhaps that site is not showing option prices that
> far out.
>
look at.
On Mon, Sep 16, 2013 at 11:55 AM, <jbooth11@gmail.
>
> It works just fine for Apple 2015 options, but just shows "error" for the
> 2016 Apple options. Am I doing something wrong? Where are the option
> quotes pulled from? Perhaps that site is not showing option prices that
> far out.
>
Mon Sep 16, 2013 6:30 pm (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Hi Randy
smfPricesByDates use Yahoo symbols, which are not available for Thailand stocks. Is there another function similar to this that works with Google symbols?
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at the smfPricesByDates() function. It does exactly that.
>
> On Tue, Jun 26, 2012 at 8:49 AM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> >
> > Is there a way to have stock ticker as row headings, date as column
> > headings and formulaes in individual cells referencing stock ticker and
> > date and returning the adjusted closing prices?
> >
>
smfPricesByDates use Yahoo symbols, which are not available for Thailand stocks. Is there another function similar to this that works with Google symbols?
--- In smf_addin@yahoogrou
>
> Take a look at the smfPricesByDates(
>
> On Tue, Jun 26, 2012 at 8:49 AM, lawrence.leesh <lawrence.
>
> >
> > Is there a way to have stock ticker as row headings, date as column
> > headings and formulaes in individual cells referencing stock ticker and
> > date and returning the adjusted closing prices?
> >
>
Mon Sep 16, 2013 9:15 pm (PDT) . Posted by:
dmatu2000
Does anyone have an update on ADVFN? Are they still working on
their layout?
--- In smf_addin@yahoogrou
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Tidak ada komentar:
Posting Komentar