11 New Messages
Digest #2263
| 1a MSN update - fail :( by "sophoclessophocleous" sophoclessophocleous 1b Re: MSN update - fail :( by "NicholasDavid" davidnicholas738 1c Re: MSN update - fail :( by "Randy Harmelink" rharmelink 1d Re: MSN update - fail :( by "Mauricio Lan" morteritos 1e Re: MSN update - fail :( by "Randy Harmelink" rharmelink 2a Problem loading ADVFN Data by "EdwinB" edwin444pr 2b Re: Problem loading ADVFN Data by "Randy Harmelink" rharmelink 3a Barchartproblem by "stefan_rainer@ymail.com" stefan_rainer@ymail.com 3b Re: Barchartproblem by "Randy Harmelink" rharmelink 3c Re: Barchartproblem by "Stefn Rai" rainerglobal@ymail.com 4 No price history for Dow Indexes at Yahoo Finance by "mgbuck55" mgbuck55 |
Mon Jul 2, 2012 5:45 am (PDT) . Posted by: "sophoclessophocleous" sophoclessophocleous
Hi,
I'm trying to use the following:
=RCHGetElementNumber(Ticker,25)
and I get error.
Same for all the other MSN i tried.
I copied and pasted the new MSN file you posted and restarted the computer but still I get error.
Any ideas?
Thanks!!!!
I'm trying to use the following:
=RCHGetElementNumbe
and I get error.
Same for all the other MSN i tried.
I copied and pasted the new MSN file you posted and restarted the computer but still I get error.
Any ideas?
Thanks!!!!
Mon Jul 2, 2012 5:52 am (PDT) . Posted by: "NicholasDavid" davidnicholas738
I had the same problem and finally gave up. Now, I use:
=RCHGetYahooQuotes(ticker2,"l1")
----- Original Message -----
From: "sophoclessophocleous" <sophoclessophocleous@yahoo.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Monday, July 2, 2012 7:45:27 AM
Subject: [smf_addin] MSN update - fail :(
Hi,
I'm trying to use the following:
=RCHGetElementNumber(Ticker,25)
and I get error.
Same for all the other MSN i tried.
I copied and pasted the new MSN file you posted and restarted the computer but still I get error.
Any ideas?
Thanks!!!!
=RCHGetYahooQuotes(
----- Original Message -----
From: "sophoclessophocleo
To: "smf addin" <smf_addin@yahoogrou
Sent: Monday, July 2, 2012 7:45:27 AM
Subject: [smf_addin] MSN update - fail :(
Hi,
I'm trying to use the following:
=RCHGetElementNumbe
and I get error.
Same for all the other MSN i tried.
I copied and pasted the new MSN file you posted and restarted the computer but still I get error.
Any ideas?
Thanks!!!!
Mon Jul 2, 2012 7:48 am (PDT) . Posted by: "Randy Harmelink" rharmelink
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(25)
=RCHGetElementNumber("MMM",25)
On Mon, Jul 2, 2012 at 5:45 AM, sophoclessophocleous <
sophoclessophocleous@yahoo.com > wrote:
>
> I'm trying to use the following:
> =RCHGetElementNumber(Ticker,25)
> and I get error.
>
> Same for all the other MSN i tried.
>
> I copied and pasted the new MSN file you posted and restarted the computer
> but still I get error.
>
> Any ideas?
>
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetElementNumbe
On Mon, Jul 2, 2012 at 5:45 AM, sophoclessophocleou
sophoclessophocleou
>
> I'm trying to use the following:
> =RCHGetElementNumbe
> and I get error.
>
> Same for all the other MSN i tried.
>
> I copied and pasted the new MSN file you posted and restarted the computer
> but still I get error.
>
> Any ideas?
>
Mon Jul 2, 2012 8:23 am (PDT) . Posted by: "Mauricio Lan" morteritos
I have the same Error.
And the Results i get are:
Stock Market Functions add-in, Version 2.1.2012.02.02
(C:\Users\hp\Downloads\RCH_Stock_Market_Functions-2.1.2012.02.02; 1)
MSN;Last Price;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK
ACTIVITY;LAST PRICE; ; ;0;0;0;0
Error
What can I do?
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, July 2, 2012 9:48 AM
Subject: Re: [smf_addin] MSN update - fail :(
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(25)
=RCHGetElementNumber("MMM",25)
On Mon, Jul 2, 2012 at 5:45 AM, sophoclessophocleous <sophoclessophocleous@yahoo.com > wrote:
>I'm trying to use the following:
>=RCHGetElementNumber(Ticker,25)
>and I get error.
>
>Same for all the other MSN i tried.
>
>I copied and pasted the new MSN file you posted and restarted the computer but still I get error.
>
>Any ideas?
>
And the Results i get are:
Stock Market Functions add-in, Version 2.1.2012.02.
(C:\Users\hp\
MSN;Last Price;http://moneycentral
ACTIVITY;LAST PRICE; ; ;0;0;0;0
Error
What can I do?
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, July 2, 2012 9:48 AM
Subject: Re: [smf_addin] MSN update - fail :(
What do you get for:
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetElementNumbe
On Mon, Jul 2, 2012 at 5:45 AM, sophoclessophocleou
>I'm trying to use the following:
>=RCHGetElementNumb
>and I get error.
>
>Same for all the other MSN i tried.
>
>I copied and pasted the new MSN file you posted and restarted the computer but still I get error.
>
>Any ideas?
>
Mon Jul 2, 2012 8:33 am (PDT) . Posted by: "Randy Harmelink" rharmelink
You're getting the error because you still need to update the
smf-element-1.txt file. The element definition you show below is the old
one. The new file has this definition:
MSN;Last Price;
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST
PRICE; ; ;0;0;0;0
Note the different URL.
On Mon, Jul 2, 2012 at 8:23 AM, Mauricio Lan <morteritos@yahoo.com > wrote:
>
> I have the same Error.
>
> And the Results i get are:
>
> Stock Market Functions add-in, Version 2.1.2012.02.02
> (C:\Users\hp\Downloads\RCH_**Stock_Market_Functions-2.1.**2012.02.02; 1)
> MSN;Last Price;http://moneycentral.msn.**com/investor/research/sreport.**
> asp?CR=1&AF=1&IH=1&AIE=1&AIR=**1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=**
> 1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=**1&ITP=1&Type=Equity&Symbol=~~~**~~;1;STOCK<http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=%7E%7E%7E%7E%7E;1;STOCK >
> ACTIVITY;LAST PRICE; ; ;0;0;0;0
> Error
>
> What can I do?
>
smf-element-
one. The new file has this definition:
MSN;Last Price;
http://investing.
PRICE; ; ;0;0;0;0
Note the different URL.
On Mon, Jul 2, 2012 at 8:23 AM, Mauricio Lan <morteritos@yahoo.
>
> I have the same Error.
>
> And the Results i get are:
>
> Stock Market Functions add-in, Version 2.1.2012.02.
> (C:\Users\hp\
> MSN;Last Price;http://moneycentral
> asp?CR=1&AF=
> 1&BSQ=1&CFA=
> ACTIVITY;LAST PRICE; ; ;0;0;0;0
> Error
>
> What can I do?
>
Mon Jul 2, 2012 12:45 pm (PDT) . Posted by: "EdwinB" edwin444pr
I recently changed internet service provider (ISP). The problem is that now I cannot load ADVFN data to my excel sheet nor I can access the ADVFN webpage. I thought it was a problem with my new ISP but recently I tried loading the same excel sheet and ADVFN webpage using a neighbor's connection (which has the same ISP) and both my sheet and the webpage worked.
Has anyone experienced this problem before and is there a solution to it?
Has anyone experienced this problem before and is there a solution to it?
Mon Jul 2, 2012 2:05 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
You can try the AdvFN fix from the LINKS area of the group, to see if that
helps...
Otherwise, if your browser can't even access the site, I'm baffled. That to
me would indicate some type of firewall is stopping access.
On Mon, Jul 2, 2012 at 10:25 AM, EdwinB <edwin444pr@yahoo.com > wrote:
> I recently changed internet service provider (ISP). The problem is that
> now I cannot load ADVFN data to my excel sheet nor I can access the ADVFN
> webpage. I thought it was a problem with my new ISP but recently I tried
> loading the same excel sheet and ADVFN webpage using a neighbor's
> connection (which has the same ISP) and both my sheet and the webpage
> worked.
>
> Has anyone experienced this problem before and is there a solution to it?
>
helps...
Otherwise, if your browser can't even access the site, I'm baffled. That to
me would indicate some type of firewall is stopping access.
On Mon, Jul 2, 2012 at 10:25 AM, EdwinB <edwin444pr@yahoo.
> I recently changed internet service provider (ISP). The problem is that
> now I cannot load ADVFN data to my excel sheet nor I can access the ADVFN
> webpage. I thought it was a problem with my new ISP but recently I tried
> loading the same excel sheet and ADVFN webpage using a neighbor's
> connection (which has the same ISP) and both my sheet and the webpage
> worked.
>
> Has anyone experienced this problem before and is there a solution to it?
>
Mon Jul 2, 2012 5:43 pm (PDT) . Posted by: "stefan_rainer@ymail.com" stefan_rainer@ymail.com
Hi, I was using RCHGetWebData("http://charts.barchart.com/chart.asp?sym= "&Ticker&"&data="&LEFT(Period,FIND(" ",Period)-1)&"&den=HIGH&vol=Y") in order to retrieve historic Barchart data. This does not seem to work any more. Does anyone know how to find the sourcecode so the data will extract again?
Best Regards
Best Regards
Mon Jul 2, 2012 6:46 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
Sorry, but it looks like BarChart is no longer putting the quotes into the
source code of the web page, but doing the process dynamically now. So
there is nothing in the source code of the web page for the add-in to
extract.
On Mon, Jul 2, 2012 at 4:59 PM, stefan_rainer@ymail.com <
stefan_rainer@ymail.com > wrote:
> Hi, I was using RCHGetWebData("http://charts.barchart.com/chart.asp?sym= "&Ticker&"&data="&LEFT(Period,FIND("
> ",Period)-1)&"&den=HIGH&vol=Y") in order to retrieve historic Barchart
> data. This does not seem to work any more. Does anyone know how to find the
> sourcecode so the data will extract again?
>
source code of the web page, but doing the process dynamically now. So
there is nothing in the source code of the web page for the add-in to
extract.
On Mon, Jul 2, 2012 at 4:59 PM, stefan_rainer@
stefan_rainer@
> Hi, I was using RCHGetWebData(
> ",Period)-1)
> data. This does not seem to work any more. Does anyone know how to find the
> sourcecode so the data will extract again?
>
Mon Jul 2, 2012 8:34 pm (PDT) . Posted by: "Stefn Rai" rainerglobal@ymail.com
Does somebody know where to get historic high,low,close for currencies and futures, since Barchart is not giving the source code any more? .
Regards,
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, July 3, 2012 3:46 AM
Subject: Re: [smf_addin] Barchartproblem
Sorry, but it looks like BarChart is no longer putting the quotes into the source code of the web page, but doing the process dynamically now. So there is nothing in the source code of the web page for the add-in to extract.
On Mon, Jul 2, 2012 at 4:59 PM, stefan_rainer@ymail.com <stefan_rainer@ymail.com > wrote:
Hi, I was using RCHGetWebData("http://charts.barchart.com/chart.asp?sym= "&Ticker&"&data="&LEFT(Period,FIND(" ",Period)-1)&"&den=HIGH&vol=Y") in order to retrieve historic Barchart data. This does not seem to work any more. Does anyone know how to find the sourcecode so the data will extract again?
>
Regards,
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Tuesday, July 3, 2012 3:46 AM
Subject: Re: [smf_addin] Barchartproblem
Sorry, but it looks like BarChart is no longer putting the quotes into the source code of the web page, but doing the process dynamically now. So there is nothing in the source code of the web page for the add-in to extract.
On Mon, Jul 2, 2012 at 4:59 PM, stefan_rainer@
Hi, I was using RCHGetWebData(
>
Tue Jul 3, 2012 4:05 am (PDT) . Posted by: "mgbuck55" mgbuck55
Last night I noticed that Yahoo Finance was not providing historical prices for ^DJI, ^DJT, or ^DJU. Current quotes were updating but the previous prices were gone. Anyone else notice this problem? If so is this a permanent change?
Tidak ada komentar:
Posting Komentar