11 New Messages
Digest #2389
Messages
Fri Nov 2, 2012 6:57 am (PDT) . Posted by:
"taurines_morgan" taurines_morgan
hi,
the getyahooquotes function seems to return an erroneous value
for eurusd, eurchf, eursgd exchange rates??
can someone confirm me that?
thanks
morgan
the getyahooquotes function seems to return an erroneous value
for eurusd, eurchf, eursgd exchange rates??
can someone confirm me that?
thanks
morgan
Fri Nov 2, 2012 7:33 am (PDT) . Posted by:
"lexstar" lexstar
This really puzzles me. I have a number of worksheets with this smfPricesBetween() function and others as well. Some days, the functions work fine. Other days, like today, when I manually update, the only things I get are blank dates and 0 prices. I don't know if this is (1) an Excel issue, (2) smfPricesBetween() issue, (3) Yahoo data issue, (4) other issue.
If I take the same workbook to another computer, and manually update it, it works fine. So, this tells me that there's something with this one computer and/or Excel on this computer.
My workbook is 500MB in size and has several worksheets- some worksheets are used to download data, while others are used to analyze those data and a couple of worksheets are used to display the data and show embedded graphs.
I don't know if anyone can help, but I just want to know what could be causing the problem... I need the data to be downloaded.
Thanks in advance.
If I take the same workbook to another computer, and manually update it, it works fine. So, this tells me that there's something with this one computer and/or Excel on this computer.
My workbook is 500MB in size and has several worksheets- some worksheets are used to download data, while others are used to analyze those data and a couple of worksheets are used to display the data and show embedded graphs.
I don't know if anyone can help, but I just want to know what could be causing the problem... I need the data to be downloaded.
Thanks in advance.
Fri Nov 2, 2012 7:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Does the erroneous computer typically get run at a different time of day?
Most of the time that I would get bad historical quotes, it would be early
in the morning, when Yahoo was updating things.
On Fri, Nov 2, 2012 at 7:33 AM, lexstar <lexstar@yahoo.com > wrote:
> This really puzzles me. I have a number of worksheets with this
> smfPricesBetween() function and others as well. Some days, the functions
> work fine. Other days, like today, when I manually update, the only things
> I get are blank dates and 0 prices. I don't know if this is (1) an Excel
> issue, (2) smfPricesBetween() issue, (3) Yahoo data issue, (4) other issue.
>
> If I take the same workbook to another computer, and manually update it,
> it works fine. So, this tells me that there's something with this one
> computer and/or Excel on this computer.
>
> My workbook is 500MB in size and has several worksheets- some worksheets
> are used to download data, while others are used to analyze those data and
> a couple of worksheets are used to display the data and show embedded
> graphs.
>
> I don't know if anyone can help, but I just want to know what could be
> causing the problem... I need the data to be downloaded.
>
> Thanks in advance.
>
Most of the time that I would get bad historical quotes, it would be early
in the morning, when Yahoo was updating things.
On Fri, Nov 2, 2012 at 7:33 AM, lexstar <lexstar@yahoo.
> This really puzzles me. I have a number of worksheets with this
> smfPricesBetween(
> work fine. Other days, like today, when I manually update, the only things
> I get are blank dates and 0 prices. I don't know if this is (1) an Excel
> issue, (2) smfPricesBetween(
>
> If I take the same workbook to another computer, and manually update it,
> it works fine. So, this tells me that there's something with this one
> computer and/or Excel on this computer.
>
> My workbook is 500MB in size and has several worksheets- some worksheets
> are used to download data, while others are used to analyze those data and
> a couple of worksheets are used to display the data and show embedded
> graphs.
>
> I don't know if anyone can help, but I just want to know what could be
> causing the problem... I need the data to be downloaded.
>
> Thanks in advance.
>
Fri Nov 2, 2012 8:31 pm (PDT) . Posted by:
"lexstar" lexstar
Didn't matter what time of the day it is. I've tried at various times, and it still doesn't work.
I just don't get it.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Does the erroneous computer typically get run at a different time of day?
> Most of the time that I would get bad historical quotes, it would be early
> in the morning, when Yahoo was updating things.
>
> On Fri, Nov 2, 2012 at 7:33 AM, lexstar <lexstar@...> wrote:
>
> > This really puzzles me. I have a number of worksheets with this
> > smfPricesBetween() function and others as well. Some days, the functions
> > work fine. Other days, like today, when I manually update, the only things
> > I get are blank dates and 0 prices. I don't know if this is (1) an Excel
> > issue, (2) smfPricesBetween() issue, (3) Yahoo data issue, (4) other issue.
> >
> > If I take the same workbook to another computer, and manually update it,
> > it works fine. So, this tells me that there's something with this one
> > computer and/or Excel on this computer.
> >
> > My workbook is 500MB in size and has several worksheets- some worksheets
> > are used to download data, while others are used to analyze those data and
> > a couple of worksheets are used to display the data and show embedded
> > graphs.
> >
> > I don't know if anyone can help, but I just want to know what could be
> > causing the problem... I need the data to be downloaded.
> >
> > Thanks in advance.
> >
>
I just don't get it.
--- In smf_addin@yahoogrou
>
> Does the erroneous computer typically get run at a different time of day?
> Most of the time that I would get bad historical quotes, it would be early
> in the morning, when Yahoo was updating things.
>
> On Fri, Nov 2, 2012 at 7:33 AM, lexstar <lexstar@...
>
> > This really puzzles me. I have a number of worksheets with this
> > smfPricesBetween(
> > work fine. Other days, like today, when I manually update, the only things
> > I get are blank dates and 0 prices. I don't know if this is (1) an Excel
> > issue, (2) smfPricesBetween(
> >
> > If I take the same workbook to another computer, and manually update it,
> > it works fine. So, this tells me that there's something with this one
> > computer and/or Excel on this computer.
> >
> > My workbook is 500MB in size and has several worksheets- some worksheets
> > are used to download data, while others are used to analyze those data and
> > a couple of worksheets are used to display the data and show embedded
> > graphs.
> >
> > I don't know if anyone can help, but I just want to know what could be
> > causing the problem... I need the data to be downloaded.
> >
> > Thanks in advance.
> >
>
Fri Nov 2, 2012 8:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you tried an immediate smfForceRecalculation? Same results, or does it
then update?
No unresolved links, right?
On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@yahoo.com > wrote:
> Didn't matter what time of the day it is. I've tried at various times,
> and it still doesn't work.
>
> I just don't get it.
>
then update?
No unresolved links, right?
On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@yahoo.
> Didn't matter what time of the day it is. I've tried at various times,
> and it still doesn't work.
>
> I just don't get it.
>
Fri Nov 2, 2012 7:10 pm (PDT) . Posted by:
"llfinancemarket2012" llfinancemarket2012
Hi,
I'm new to smf, I was wondering if there's any chance to retrieve real time volume values.
Many thanks.
Luca
I'm new to smf, I was wondering if there's any chance to retrieve real time volume values.
Many thanks.
Luca
Fri Nov 2, 2012 7:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As I understand it, if you sign up for real time values and are logged in
via IE, RCHGetYahooQuotes() will return real-time values. Otherwise, if you
have a data source, we could see if the add-in can retrieve the data.
On Fri, Nov 2, 2012 at 4:04 AM, llfinancemarket2012 <luca.lavaroni@gmail.com
> wrote:
>
> I'm new to smf, I was wondering if there's any chance to retrieve real
> time volume values.
>
via IE, RCHGetYahooQuotes(
have a data source, we could see if the add-in can retrieve the data.
On Fri, Nov 2, 2012 at 4:04 AM, llfinancemarket2012 <luca.lavaroni@
> wrote:
>
> I'm new to smf, I was wondering if there's any chance to retrieve real
> time volume values.
>
Fri Nov 2, 2012 8:51 pm (PDT) . Posted by:
"Jacob Jose" pepecan47
Do you know of any site and/or a formula where I can extract the US$ vs CDN$ exchange rate?
Thx a lot.
Regards,
Jose L. Jacob
Thx a lot.
Regards,
Jose L. Jacob
Sat Nov 3, 2012 2:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Use RCHGetYahooQuotes(). The ticker symbols would be USDCAD=X or CADUSD=X.
On Fri, Nov 2, 2012 at 8:51 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> Do you know of any site and/or a formula where I can extract the US$ vs
> CDN$ exchange rate?
>
>
On Fri, Nov 2, 2012 at 8:51 PM, Jacob Jose <pepecan47@yahoo.
>
> Do you know of any site and/or a formula where I can extract the US$ vs
> CDN$ exchange rate?
>
>
Fri Nov 2, 2012 11:01 pm (PDT) . Posted by:
"FroZeNDowNloaD" FroZeNDowNloaD
I'm trying to pull last 10 year values from the data source MorningstarAR for instance RCHGetElementNumber 14030 but I'm only coming up with either blank numbers or for P/S (14007), I get errors.
Did something change with morningstar?
Did something change with morningstar?
Sat Nov 3, 2012 2:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like they changed the webpage. It's now dynamically produced, so the
data is no longer available to the add-in.
On Fri, Nov 2, 2012 at 11:01 PM, FroZeNDowNloaD <moonglows@gmail.com > wrote:
> I'm trying to pull last 10 year values from the data source MorningstarAR
> for instance RCHGetElementNumber 14030 but I'm only coming up with either
> blank numbers or for P/S (14007), I get errors.
>
> Did something change with morningstar?
>
data is no longer available to the add-in.
On Fri, Nov 2, 2012 at 11:01 PM, FroZeNDowNloaD <moonglows@gmail.
> I'm trying to pull last 10 year values from the data source MorningstarAR
> for instance RCHGetElementNumber 14030 but I'm only coming up with either
> blank numbers or for P/S (14007), I get errors.
>
> Did something change with morningstar?
>
Tidak ada komentar:
Posting Komentar