12 New Messages
Digest #2819
Messages
Sun Oct 20, 2013 7:53 am (PDT) . Posted by:
"Lao Si" laosilok
Dear I am using excel 2007, after add-in ask the menu, however it is not working
is there any one can advise me what can be done to make it work
tks for your help in advance
Cecilia
is there any one can advise me what can be done to make it work
tks for your help in advance
Cecilia
Sun Oct 20, 2013 8:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What's not working? The add-in won't show up on a menu, except for the
add-in manager. It's primarily a collection of user-defined functions.
On Sun, Oct 20, 2013 at 6:13 AM, Lao Si <laosilok@yahoo.com> wrote:
>
> Dear I am using excel 2007, after add-in ask the menu, however it is not
> working
>
> is there any one can advise me what can be done to make it work
>
>
add-in manager. It's primarily a collection of user-defined functions.
On Sun, Oct 20, 2013 at 6:13 AM, Lao Si <laosilok@yahoo.
>
> Dear I am using excel 2007, after add-in ask the menu, however it is not
> working
>
> is there any one can advise me what can be done to make it work
>
>
Sun Oct 20, 2013 8:54 am (PDT) . Posted by:
"Lao Si" laosilok
Dear Randy
Tks for your prompt reply.
I think the function should be able to show up. however it cannot. I have screen capture it for your advise.
Sorry to give you trouble.
your advise is very importance
tks in advance
Cecilia
On Sunday, October 20, 2013 11:27 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
What's not working? The add-in won't show up on a menu, except for the add-in manager. It's primarily a collection of user-defined functions.
On Sun, Oct 20, 2013 at 6:13 AM, Lao Si <laosilok@yahoo.com> wrote:
>
>Dear I am using excel 2007, after add-in ask the menu, however it is not working
>
>
>is there any one can advise me what can be done to make it work
>
Tks for your prompt reply.
I think the function should be able to show up. however it cannot. I have screen capture it for your advise.
Sorry to give you trouble.
your advise is very importance
tks in advance
Cecilia
On Sunday, October 20, 2013 11:27 PM, Randy Harmelink <rharmelink@gmail.
What's not working? The add-in won't show up on a menu, except for the add-in manager. It's primarily a collection of user-defined functions.
On Sun, Oct 20, 2013 at 6:13 AM, Lao Si <laosilok@yahoo.
>
>Dear I am using excel 2007, after add-in ask the menu, however it is not working
>
>
>is there any one can advise me what can be done to make it work
>
Attachments with this message:
1 of 1 Photo(s)
Sun Oct 20, 2013 9:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They show up in mine, in the "All" category. The best place to learn about
the functions is from the "Documentation" folder in the FILES area of the
group.
If you want to see if the add-in is installed properly, try:
=RCHGetElementNumber("Version")
...and it should tell you which version of the add-in you have installed.
On Sun, Oct 20, 2013 at 8:54 AM, Lao Si <laosilok@yahoo.com> wrote:
>
> I think the function should be able to show up. however it cannot. I have
> screen capture it for your advise.
>
the functions is from the "Documentation
group.
If you want to see if the add-in is installed properly, try:
=RCHGetElementNumbe
...and it should tell you which version of the add-in you have installed.
On Sun, Oct 20, 2013 at 8:54 AM, Lao Si <laosilok@yahoo.
>
> I think the function should be able to show up. however it cannot. I have
> screen capture it for your advise.
>
Sun Oct 20, 2013 9:57 am (PDT) . Posted by:
"Lao Si" laosilok
Tks Randy
I got it. Thanks for you indication.
you are so kind.
Cheers
Cecilia
On Sunday, October 20, 2013 11:57 PM, Lao Si <laosilok@yahoo.com> wrote:
[Attachment(s) from Lao Si included below]
Dear Randy
Tks for your prompt reply.
I think the function should be able to show up. however it cannot. I have screen capture it for your advise.
Sorry to give you trouble.
your advise is very importance
tks in advance
Cecilia
On Sunday, October 20, 2013 11:27 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
What's not working? The add-in won't show up on a menu, except for the add-in manager. It's primarily a collection of user-defined functions.
On Sun, Oct 20, 2013 at 6:13 AM, Lao Si <laosilok@yahoo.com> wrote:
>
>Dear I am using excel 2007, after add-in ask the menu, however it is not working
>
>
>is there any one can advise me what can be done to make it work
>
I got it. Thanks for you indication.
you are so kind.
Cheers
Cecilia
On Sunday, October 20, 2013 11:57 PM, Lao Si <laosilok@yahoo.
[Attachment(
Dear Randy
Tks for your prompt reply.
I think the function should be able to show up. however it cannot. I have screen capture it for your advise.
Sorry to give you trouble.
your advise is very importance
tks in advance
Cecilia
On Sunday, October 20, 2013 11:27 PM, Randy Harmelink <rharmelink@gmail.
What's not working? The add-in won't show up on a menu, except for the add-in manager. It's primarily a collection of user-defined functions.
On Sun, Oct 20, 2013 at 6:13 AM, Lao Si <laosilok@yahoo.
>
>Dear I am using excel 2007, after add-in ask the menu, however it is not working
>
>
>is there any one can advise me what can be done to make it work
>
Sun Oct 20, 2013 7:53 am (PDT) . Posted by:
tonybellingham
Would anyone care to provide a turnkey smf_addin, for a fee. The spreadsheet is ultra simple except for one aspect: sorting three SPARKLINES per row on the Summary Sheet from source data on Sheet!2,3,4.. Have a working model under Google Sheets & Excel mockup, all self explanatory, can send both files immediately. I'm out of my league here but like to take a shot. Please give me a good kicking if soliciting is prohibited on the Group and accept my sincere apologies.
Tony
Tony
Sun Oct 20, 2013 4:10 pm (PDT) . Posted by:
paul84j
Hi Randy,
I rely on AdvFN data from the 'uk' region which is no longer working and I'm a bit stumped. I'm running the latest Beta version of the add-in.
I suspect that the file you mention in the previous post, smf-AdvFN-Prefix.txt, could be helpful but I can't find this file. It's not in the folder with the add-in.
I manually changed the www to uk in the code but this had no effect - still getting 'Error' everywhere. ANy help would be appreciated.
Thanks.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
It's the smf-AdvFN-Prefix.txt file that is in the folder with the add-in. Either delete that file or change the content to be just "www" (without the quotes).
On Sat, Oct 19, 2013 at 10:44 AM, <pc_babe@... mailto:pc_babe@...> wrote:
Previously I had made the suggested .IB change. Can you remind me please which file that applied to so I can go back and remove.
I rely on AdvFN data from the 'uk' region which is no longer working and I'm a bit stumped. I'm running the latest Beta version of the add-in.
I suspect that the file you mention in the previous post, smf-AdvFN-Prefix.
I manually changed the www to uk in the code but this had no effect - still getting 'Error&#
Thanks.
---In smf_addin@yahoogrou
It's the smf-AdvFN-Prefix.
On Sat, Oct 19, 2013 at 10:44 AM, <pc_babe@
Previously I had made the suggested .IB change. Can you remind me please which file that applied to so I can go back and remove.
Sun Oct 20, 2013 4:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to create the smf-AdvFN-Prefix.txt file if you need it.
The add-in defaults to "www" as an AdvFN prefix if that file is missing.
But if you create that file and put your prefix into (i.e. "uk" without the
quotes), then it will use that as the prefix instead of "www".
I did it that way so later distributions of the add-in wouldn't overwrite
the file, or manual changes to the VBA code.
However, with the changes AdvFN has made, I'm not sure if the prefix works
like it used to or not.
I tried looking at a few companies on the LSE (BLT and RMG), and I don't
see any annual or quarterly financials.
On Sun, Oct 20, 2013 at 4:10 PM, <paul84j@yahoo.ie> wrote:
> I rely on AdvFN data from the 'uk' region which is no longer working and
> I'm a bit stumped. I'm running the latest Beta version of the add-in.
>
> I suspect that the file you mention in the previous post,
> smf-AdvFN-Prefix.txt, could be helpful but I can't find this file. It's
> not in the folder with the add-in.
>
> I manually changed the www to uk in the code but this had no effect -
> still getting 'Error' everywhere. ANy help would be appreciated.
>
The add-in defaults to "www" as an AdvFN prefix if that file is missing.
But if you create that file and put your prefix into (i.e. "uk" without the
quotes), then it will use that as the prefix instead of "www"
I did it that way so later distributions of the add-in wouldn't overwrite
the file, or manual changes to the VBA code.
However, with the changes AdvFN has made, I'm not sure if the prefix works
like it used to or not.
I tried looking at a few companies on the LSE (BLT and RMG), and I don't
see any annual or quarterly financials.
On Sun, Oct 20, 2013 at 4:10 PM, <paul84j@yahoo.
> I rely on AdvFN data from the 'uk' region which is no longer working and
> I'm a bit stumped. I'm running the latest Beta version of the add-in.
>
> I suspect that the file you mention in the previous post,
> smf-AdvFN-Prefix.
> not in the folder with the add-in.
>
> I manually changed the www to uk in the code but this had no effect -
> still getting 'Error&#
>
Sun Oct 20, 2013 5:05 pm (PDT) . Posted by:
paul84j
Thanks for the quick reply Randy. It looks like I'm stuck then, I created that file but still have the same problem.
Interestingly, just to check one of the companies you mentioned, I searched for BLT on the uk.advfn.com site and here is the URL that came up:
http://uk.advfn.com/common/financial/LSE/bhp-billiton-BLT/income-statement?pm=Q
BLT is the ticker for BHP Billiton on the LSE and is also the ticker for Blount International on the NYSE. Advfn is confusing the two and wrongly shows the Blount International financial data for BHP Billiton!! So yes,the financial statements are there but they are for the wrong company! What is going on with AdvFN??
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
You need to create the smf-AdvFN-Prefix.txt file if you need it.
The add-in defaults to "www" as an AdvFN prefix if that file is missing. But if you create that file and put your prefix into (i.e. "uk" without the quotes), then it will use that as the prefix instead of "www".
I did it that way so later distributions of the add-in wouldn't overwrite the file, or manual changes to the VBA code.
However, with the changes AdvFN has made, I'm not sure if the prefix works like it used to or not.
I tried looking at a few companies on the LSE (BLT and RMG), and I don't see any annual or quarterly financials.
On Sun, Oct 20, 2013 at 4:10 PM, <paul84j@... mailto:paul84j@...> wrote:
I rely on AdvFN data from the 'uk' region which is no longer working and I'm a bit stumped. I'm running the latest Beta version of the add-in.
I suspect that the file you mention in the previous post, smf-AdvFN-Prefix.txt, could be helpful but I can't find this file. It's not in the folder with the add-in.
I manually changed the www to uk in the code but this had no effect - still getting 'Error' everywhere. ANy help would be appreciated.
Interestingly, just to check one of the companies you mentioned, I searched for BLT on the uk.advfn.com site and here is the URL that came up:
http://uk.advfn.
BLT is the ticker for BHP Billiton on the LSE and is also the ticker for Blount International on the NYSE. Advfn is confusing the two and wrongly shows the Blount International financial data for BHP Billiton!! So yes,the financial statements are there but they are for the wrong company! What is going on with AdvFN??
---In smf_addin@yahoogrou
You need to create the smf-AdvFN-Prefix.
The add-in defaults to "www" as an AdvFN prefix if that file is missing. But if you create that file and put your prefix into (i.e. "uk" without the quotes), then it will use that as the prefix instead of "www"
I did it that way so later distributions of the add-in wouldn't overwrite the file, or manual changes to the VBA code.
However, with the changes AdvFN has made, I'm not sure if the prefix works like it used to or not.
I tried looking at a few companies on the LSE (BLT and RMG), and I don't see any annual or quarterly financials.
On Sun, Oct 20, 2013 at 4:10 PM, <paul84j@
I rely on AdvFN data from the 'uk' region which is no longer working and I'm a bit stumped. I'm running the latest Beta version of the add-in.
I suspect that the file you mention in the previous post, smf-AdvFN-Prefix.
I manually changed the www to uk in the code but this had no effect - still getting 'Error&#
Sun Oct 20, 2013 5:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
How did you get to that page?
If I go to uk.advfn.com and type BLT into the ticker symbol box, I end up
here:
http://uk.advfn.com/p.php?pid=qkquote&btn=&epic=BLT&symbol=
...and I don't see any link to financial data. And if I click on the BLT
link here:
http://uk.advfn.com/exchanges/LSE/B
...I end up here:
http://uk.advfn.com/exchanges/LSE/bhp-billiton-BLT/share-price
Also no links to financial data?
On Sun, Oct 20, 2013 at 5:05 PM, <paul84j@yahoo.ie> wrote:
> Interestingly, just to check one of the companies you mentioned, I
> searched for BLT on the uk.advfn.com site and here is the URL that came
> up:
>
>
> http://uk.advfn.com/common/financial/LSE/bhp-billiton-BLT/income-statement?pm=Q
>
> BLT is the ticker for BHP Billiton on the LSE and is also the ticker for
> Blount International on the NYSE. Advfn is confusing the two and wrongly
> shows the Blount International financial data for BHP Billiton!! So
> yes,the financial statements are there but they are for the wrong company!
> What is going on with AdvFN??
>
If I go to uk.advfn.com and type BLT into the ticker symbol box, I end up
here:
http://uk.advfn.
...and I don't see any link to financial data. And if I click on the BLT
link here:
http://uk.advfn.
...I end up here:
http://uk.advfn.
Also no links to financial data?
On Sun, Oct 20, 2013 at 5:05 PM, <paul84j@yahoo.
> Interestingly, just to check one of the companies you mentioned, I
> searched for BLT on the uk.advfn.com site and here is the URL that came
> up:
>
>
> http://uk.advfn.
>
> BLT is the ticker for BHP Billiton on the LSE and is also the ticker for
> Blount International on the NYSE. Advfn is confusing the two and wrongly
> shows the Blount International financial data for BHP Billiton!! So
> yes,the financial statements are there but they are for the wrong company!
> What is going on with AdvFN??
>
Sun Oct 20, 2013 11:13 pm (PDT) . Posted by:
youval_marks
how can i get forex foreign exchange fx quotes (i put all words in to make it easier to search for this post!) to work with this addin?
eg i tried using =smfPricesByDates($B21,R$6) where b21="AUDUSD=X" and r6=41534 and it gives #NA
and for other currency pairs, it will give a number , but that number will not vary by date
eg i tried using =smfPricesByDates(
and for other currency pairs, it will give a number , but that number will not vary by date
Sun Oct 20, 2013 11:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo doesn't carry historical quotes on forex pairs...at least not the
AUD/USD pair.
Check out this template in the files area:
RCHGetTableCell-Template-Pacific-Exchange-Rate.xls
But it can only go back about 4 years for data.
That source also produces a CSV file. For example:
http://fx.sauder.ubc.ca/cgi/fxdata?b=USD&c=AUD&rd=&fd=1&fm=1&fy=2012&ld=31&lm=12&ly=2013&y=daily&q=volume&f=csv&o=
On Sun, Oct 20, 2013 at 11:13 PM, <youval_marks@yahoo.co.uk> wrote:
>
> how can i get forex foreign exchange fx quotes (i put all words in to make
> it easier to search for this post!) to work with this addin?
>
> eg i tried using =smfPricesByDates($B21,R$6) where b21="AUDUSD=X" and
> r6=41534 and it gives #NA
> and for other currency pairs, it will give a number , but that number will
> not vary by date
>
AUD/USD pair.
Check out this template in the files area:
RCHGetTableCell-
But it can only go back about 4 years for data.
That source also produces a CSV file. For example:
http://fx.sauder.
On Sun, Oct 20, 2013 at 11:13 PM, <youval_marks@
>
> how can i get forex foreign exchange fx quotes (i put all words in to make
> it easier to search for this post!) to work with this addin?
>
> eg i tried using =smfPricesByDates(
> r6=41534 and it gives #NA
> and for other currency pairs, it will give a number , but that number will
> not vary by date
>
Tidak ada komentar:
Posting Komentar