Selasa, 31 Juli 2012

]] XL-mania [[ Digest Number 2453

8 New Messages

Digest #2453

Messages

Mon Jul 30, 2012 7:18 am (PDT) . Posted by:

"Rudy Issudirman" r_issudirman

Dear Mas2 yg bisa bantu sy,
Tlg berkenan bantuin dong..., :
Berikut yg sy inginkan hasilnya:
*WEEKLY SALES DASHBOARD * *Manpower Completeness
(Total Salesman) * ** ** ** Wk I *Distributor* * Target Salesman KPI
2012 * * 2 - 7 July * * 9 - 14 July * * 16 - 21 July * *% vs. KPI* ** ** **
** ** ** ** ** PS 6 3 50% ST 8 3 38% SR JBR 6 2 33% SR
BWI 6 2 33% AK 8 3 38% TOTAL 34 13 38%
*Manpower
Completeness (Total Salesman) * ** ** ** Wk II *Distributor* * Target
Salesman KPI 2012 * * 2 - 7 July * * 9 - 14 July * * 16 - 21 July * *% vs.
KPI* Bitmap Bitmap PS 6 3 4 67% ST 8 3 5 63% SR JBR 6 2 4 67% SR BWI
6 2 3 50% AK 8 3 5 63% TOTAL 34 13 21 - 62%
*Manpower Completeness (Total Salesman) * ** ** ** Wk III
*Distributor* * Target
Salesman KPI 2012 * * 2 - 7 July * * 9 - 14 July * * 16 - 21 July * *% vs.
KPI* ** ** ** ** ** ** ** ** PS 6 3 4 5 83% ST 8 3 5 6 75% SR JBR 6
2 4 5 83% SR BWI 6 2 3 3 50% AK 8 3 5 6 75% TOTAL 34 13 21
25 74%

Rudy Issudirman
08119691863

Mon Jul 30, 2012 7:18 am (PDT) . Posted by:

"NANG Agus"

Dear Putu

Saya Coba buatkan formula ya..
Coba diganti untuk formula match menjadi:
=INDEX($B$2:$B$52;MATCH(MAX(IF($A$2:$A$51=F4;C$2:$C$51;0));IF($A$2:$A$51=F4;C$2:$C$51;0);0))
Formula array yaaa dengan jurus pamungkas Ctrl Alt Enter
Untuk Sales terburuk silahkan dibuat sendiri.
Lebih jelasnya dilihat pada lampiran.

2012/7/26 I Putu Kurniawan <emailne_atrex@yahoo.com>

> **
>
>
> Dear Rekan-rekan Excel Mania,,
>
> Mohon bantuan dan pencerahannya . . .
> Rekan-rekan, saya ada masalah dengan cara mendrag formula yang sudah saya
> buat yaitu mencari nilai tertinggi dan terendah diisi nama salesnya.
>
> Formulanya sudah saya buat dan berhasil, namun apabila di drag kebawah
> akan menghasilkan hasil yang sama dengan formula awal yang didrag.
> Untuk lebih lengkapnya mohon melihat attachment yang saya lampirkan.
>
> Bagaimanakah solusi untuk formula saya ini? agar memudahkan saya dalam
> membuat report setiap minggunya.
>
> Mohon dibantu Rekan-rekan sekalian...
>
> Terima Kasih sebelumnya atas bantuan yang diberikan...
>
>
> Salam...
>
>
> Iwan,,,
>
>
>

Mon Jul 30, 2012 6:16 pm (PDT) . Posted by:

"Alexander Ringo" alex_ringo95



Dear rekan XL-mania,

Saya baru bergabung dengan mili ini minggu lalu tetapi saya sudah banyak mendapat ilmu dari file-file arsip.

Saya coba-coba buat formula sesui file terlampir.

Tapi rumus itu hanya berfungsi jika panjang baris pada tiap "week" adalah sama.

Tolong koreksi kalau kurang tepat atau ada yang lebih praktis. Maklum masih newbie.

Semoga bisa belajar banyak dari rekan2 semua.

Salam,

Alex Ringo

From: I Putu Kurniawan [mailto:emailne_atrex@yahoo.com]
Sent: 26 Juli 2012 10:20
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ drag formula mencari nilai tertinggi dan terendah diisi nama salesnya.

Dear Rekan-rekan Excel Mania,,

Mohon bantuan dan pencerahannya . . .

Rekan-rekan, saya ada masalah dengan cara mendrag formula yang sudah saya buat yaitu mencari nilai tertinggi dan terendah diisi nama salesnya.

Formulanya sudah saya buat dan berhasil, namun apabila di drag kebawah akan menghasilkan hasil yang sama dengan formula awal yang didrag.

Untuk lebih lengkapnya mohon melihat attachment yang saya lampirkan.

Bagaimanakah solusi untuk formula saya ini? agar memudahkan saya dalam membuat report setiap minggunya.

Mohon dibantu Rekan-rekan sekalian...

Terima Kasih sebelumnya atas bantuan yang diberikan...

Salam...

Iwan,,,

Mon Jul 30, 2012 7:20 am (PDT) . Posted by:

"Firdaus Prima" captenpierre

Dear all master excel...
mau tanya, saya ini berencana untuk me 'pdf' kan beberapa file excel dan kemudian disatukan untuk menjadi satu buku dlm bentuk pdf.
Tetapi dikarenakan beberapa file excel tersebut dibuat oleh orang yang berbeda-beda. maka page layout yang dibuatpun berbeda-beda.
mungkin teman2 master excel bisa membantu saya untuk menyamakan format page layout dengan lebih mudah.

yang ingin saya samakan page layoutnya adalah :
- adjust ... %
- margin halaman
- header dan footer
- serta penomoran halaman.

Terima Kasih atas bantuannya.
Salam kenal
Firdaus

Mon Jul 30, 2012 7:20 am (PDT) . Posted by:

"Mamang Cooper" mamangcooper

rumusnya kurang lebih begini mas
=text(A4;"dd mmmm yyyy")

________________________________
Dari: Endut Karim <endutkarim@yahoo.co.id>
Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Dikirim: Selasa, 24 Juli 2012 11:47
Judul: Bls: ]] XL-mania [[ merubah format tgl


 
Yth. Mas Agung Haryanto

Rumus ini semoga berguna di Kolom B4 ketikan rumus =Value(A4)

Thanks

________________________________
Dari: Agung Haryanto <agunglombo@yahoo.com>
Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Dikirim: Jumat, 13 Juli 2012 16:13
Judul: ]] XL-mania [[ merubah format tgl


 
Dear all,
tolong bantuannya utk merubah format tanggal berikut mjd dd/mm/yyyy

thanks.

Mon Jul 30, 2012 7:20 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Mungkin cara paling sederhana adalah dengan memprotect sheet tersebut.
Jika user ingin diberi akses untuk mengupdate range tertentu, hapus centang yang ada pada kotak disebelah "Locked" (klik kanan mouse, Format Cell, Protection) sebelum Sheet diproteksi.

Salam,
Hendrik Karnadi

________________________________
From: erfan febriantoro <erfan.febriant@gmail.com>
To: XL-mania@yahoogroups.com
Sent: Sunday, 29 July 2012, 7:56
Subject: ]] XL-mania [[ Men-disable Perintah "Cut"


 
Assalamualaikum Para Master Excel,
(Salam khas edisi Ramadhan)

Jujur, banyak ilmu yg telah sy dapat di milis ini,
sehingga saya kerapkali menyelesaikan pekerjaan2 di kantor dengan lebih cepat dengan aplikasi2 sederhana yg telah saya buat.
Semoga Allah melimpahkan Hidayah dan Anugerah kepada seluruh agan-agan pencerah di milis XL-mania ini.

Namun dlm perjalanannya, seringkali aplikasi saya terganggu dan error jika digunakan orang lain, hanya karena
user menggunakan langkah "Cut - Paste" dalam mengoperasikan aplikasi sy tersebut.

Saya ingin bertanya kepada Agan-agan semua, bagaimana cara (coding) untuk men-disable fungsi "CUT" tersebut.

Thanks, God bless you.

Mon Jul 30, 2012 6:16 pm (PDT) . Posted by:

"yusranxl" yusranxl

Bagaimana caranya mengisi data di worksheet, sambil macro sedang berjalan. Apakah bisa ? Mhn bantuan teman2 yg baik. Trimakasih. Salam Sukses Semuanya.....

Mon Jul 30, 2012 6:17 pm (PDT) . Posted by:

"Aef Syaefuddin" aef.syaefuddin

Dear all,
tolong mohon bantuannya.
saya memiliki data

pada sheet1 data seperti diatas.

pada sheet 2 diinginkan sbb:

Lihat pada kolom J terdapat anggka 3, sehingga pada data di row 1 ditambahkan row dua buah,
pada data row ke 2, di tambahkan data 1 row, karena angka pada kolom J adalah 2, begitu juga untuk data di row ketiga.
kemudian data pada kolom E ke kanan di transpose dan data pada kolom B samapai kolom D di kopikan sebanyak insert row nya.

Mohon bantuannya dari para master excel.

Thanx's
GROUP FOOTER MESSAGE
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat beribadah puasa...                                        |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.29 0 komentar

[smf_addin] Digest Number 2296[2 Attachments]

12 New Messages

Digest #2296
2a
Re: =RCHGetElementNumber() by "NicholasDavid" davidnicholas738
2b
Re: =RCHGetElementNumber() [2 Attachments] by "Randy Harmelink" rharmelink
2c
Re: =RCHGetElementNumber() by "NicholasDavid" davidnicholas738
2d
Re: =RCHGetElementNumber() by "Randy Harmelink" rharmelink
2e
Re: =RCHGetElementNumber() by "NicholasDavid" davidnicholas738
3a
MACRO Question by "rb_luther" rb_luther
3b
Re: MACRO Question by "Randy Harmelink" rharmelink
4.1
RCHGetYahooQuotes by "Fred Lin" FredSLin
4.2
Re: RCHGetYahooQuotes by "Randy Harmelink" rharmelink
5a
Some Errors by "ttelip" ttelip
5b
Re: Some Errors by "Randy Harmelink" rharmelink

Messages

Mon Jul 30, 2012 6:11 am (PDT) . Posted by:

"rr76012" rr76012

Hi Randy,

I updated to the newer smf-elements-1.txt file, and re-booted, I am now working.

Thank You.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Yes, you have the old MSN element definitions, so it's the
> smf-elements-1.txt file that you need:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> On Sun, Jul 29, 2012 at 1:05 PM, NicholasDavid <nicholasdavid@...>wrote:
>
> >
> > Oh!
> > Here's what I get for these formulas:
> > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> > Files\SMF Add-In; 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;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
> > Error
> > I've been trying to fix this problem for some time.
> > In Works in progress, I see two files that might help.
> > one: RCH_Stock_Market_Functions 2.1.2012.07.12.zip
> >
> > and two: Smf-elements-1.txt
> >
> > Which of these file will make =RCHGetElementNumber(T,27) reveal the 3mth
> > price change.
> >
> > Please give me the detail of how I procedurally go about updating. I
> > thought I was smart but
> > I need help. Thanks, David
> >
>

Mon Jul 30, 2012 7:13 am (PDT) . Posted by:

"NicholasDavid" davidnicholas738

Randy,
I downloaded the updated Element text file and I still can't use some of the codes.
I have attached a simple worksheet that is trying to use =RCHGetElementNumber(symbol,27)
I have also attached the element text file I'm using.

Would you please take a look at this to see if you can see why I'm not having any success.

Thanks, David

----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Sunday, July 29, 2012 1:38:52 PM
Subject: Re: [smf_addin] =RCHGetElementNumber()

Element #27 is working here. What ticker symbol did you use? Do you have the MSN element definition updates from the "Works in Progress" folder?

Documentation of the Yahoo codes is in the "Documentation" folder in the files area of the group. Everything I am aware of is there -- I don't know of any documentation by Yahoo.

FinViz could be another source -- see the two entries in the "Links" area of the group for possible ways to extract data for multiple tickers.

On Sun, Jul 29, 2012 at 9:54 AM, ufdn16 < ufdn16@yahoo.com > wrote:

I'm getting an error in the cell that I place =RCHGetElementNumber(Symbol,27) which is supposed to return price change over 3 months.

Is there a code to get this info by using =GetYahooQuotes()

And, is there a site that has all the codes for using =GetYahooQuotes()

Attachments with this message:
2 of 2 File(s)

Mon Jul 30, 2012 8:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

My opening your file doesn't help anything, because it would use my version
of the add-in and related element definitions. And, as such, the workbook
worked fine for me. Except for SPX, which isn't a valid ticker symbol for
MSN.

Exit and restart EXCEL, and tell me what you get with these formulas in a
new workbook:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",27)
=smfGetAParms(27)

On Mon, Jul 30, 2012 at 7:12 AM, NicholasDavid <nicholasdavid@comcast.net>wrote:

>
> I downloaded the updated Element text file and I still can't use some of
> the codes.
> I have attached a simple worksheet that is trying to use
> =RCHGetElementNumber(symbol,27)
> I have also attached the element text file I'm using.
>
> Would you please take a look at this to see if you can see why I'm not
> having any success.
>

Mon Jul 30, 2012 9:26 am (PDT) . Posted by:

"NicholasDavid" davidnicholas738

Randy,
I get the following:

=RCHGetElementNumber("Version")

Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-In; 1)









=RCHGetElementNumber("MMM",27)

Error
=smfGetAParms(27)

MSN;3 Month % Price Change;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 PRICE HISTORY;LAST 3 MONTHS; ; ;0;0;0;0

----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Monday, July 30, 2012 10:31:42 AM
Subject: Re: [smf_addin] =RCHGetElementNumber()

My opening your file doesn't help anything, because it would use my version of the add-in and related element definitions. And, as such, the workbook worked fine for me. Except for SPX, which isn't a valid ticker symbol for MSN.

Exit and restart EXCEL, and tell me what you get with these formulas in a new workbook:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",27)
=smfGetAParms(27)

On Mon, Jul 30, 2012 at 7:12 AM, NicholasDavid < nicholasdavid@comcast.net > wrote:

I downloaded the updated Element text file and I still can't use some of the codes.
I have attached a simple worksheet that is trying to use =RCHGetElementNumber(symbol,27)
I have also attached the element text file I'm using.

Would you please take a look at this to see if you can see why I'm not having any success.

Mon Jul 30, 2012 9:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You still have the old element definition. Did you put the replacement file
in the correct folder -- C:\Program Files\SMF Add-In?

On Mon, Jul 30, 2012 at 9:26 AM, NicholasDavid <nicholasdavid@comcast.net>
wrote:
> I get the following:
>
> =RCHGetElementNumber("Version")
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
Files\SMF Add-In; 1)
>
> =RCHGetElementNumber("MMM",27)
>
> Error
>
> =smfGetAParms(27)
>
> MSN;3 Month % Price Change;
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;STOCKPRICE
HISTORY;LAST 3 MONTHS; ; ;0;0;0;0

Mon Jul 30, 2012 12:57 pm (PDT) . Posted by:

"NicholasDavid" davidnicholas738

Randy,

All's well. My problem was that I had two locations on my computer for SMF Add-In.
One under C:\programs\smf add-in and one under c:\documents\smf add-in.

When I downloaded the new file, it went into c:\documents\smf add-in.

Thanks for your patience. Everything works now. David

----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Monday, July 30, 2012 11:29:00 AM
Subject: Re: [smf_addin] =RCHGetElementNumber()

You still have the old element definition. Did you put the replacement file in the correct folder -- C:\Program Files\SMF Add-In?

On Mon, Jul 30, 2012 at 9:26 AM, NicholasDavid < nicholasdavid@comcast.net > wrote:
> I get the following:
>
> =RCHGetElementNumber("Version")
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-In; 1)
>
> =RCHGetElementNumber("MMM",27)
>
> Error
>
> =smfGetAParms(27)
>
> MSN;3 Month % Price Change; 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 PRICE HISTORY;LAST 3 MONTHS; ; ;0;0;0;0

Mon Jul 30, 2012 4:52 pm (PDT) . Posted by:

"rb_luther" rb_luther

Is there a way to write a macro to retrieve financial statement data from the advfn website and then depending on the rows specified paste that data into excel. (Basically running the macro in background and then pasting the data into excel without using a formula in each cell to retrieve the lines.) I'm looking to retrieve ADVFN data more efficiently (decrease processing time) than using the getADVFN formula in numerous cells.

Is the processing time long due to the formula in each cell retrieving one by one, or is it due to having to open numerous web pages to retrieve the data for different time frames and different tickers?

Lastly, there is a macro that I have used in the past to retrieve data from the finviz website and it is much faster processing time than using the formulas in the cell with the smfaddin macros. Is this due to the finviz website being able to export csv files and then retrieve the data from the csv in the background as opposed to retrieving data from an html table? If so, is there a way to convert the html table on advfn to a csv file to run more efficiently?

Thanks for the help.

Mon Jul 30, 2012 5:03 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There are two reasons AdvFN takes longer than most other sites:

1. They only have 5 periods of data on a page. So if you want 20 annual
periods and 40 quarterly periods, you need to access 12 web pages to get
the data for a single ticker symbol.

2. Each web page has a lot of data on it, so if you extract a lot of
data from the web page, they do take longer to search for and extract than
a smaller web page.

You may be able to speed it up by doing RCHGetHTMLTable() on each of the 12
web pages, if you're getting all of the data.

I get FinViz data quickly, but I do use their CSV file (see LINKS area of
the group for more info). Depending on how you're getting the data, and how
much data you're getting, it can be a lot slower getting things
individually.
On Mon, Jul 30, 2012 at 4:52 PM, rb_luther <rb_luther@yahoo.com> wrote:

> Is there a way to write a macro to retrieve financial statement data from
> the advfn website and then depending on the rows specified paste that data
> into excel. (Basically running the macro in background and then pasting the
> data into excel without using a formula in each cell to retrieve the
> lines.) I'm looking to retrieve ADVFN data more efficiently (decrease
> processing time) than using the getADVFN formula in numerous cells.
>
> Is the processing time long due to the formula in each cell retrieving one
> by one, or is it due to having to open numerous web pages to retrieve the
> data for different time frames and different tickers?
>
> Lastly, there is a macro that I have used in the past to retrieve data
> from the finviz website and it is much faster processing time than using
> the formulas in the cell with the smfaddin macros. Is this due to the
> finviz website being able to export csv files and then retrieve the data
> from the csv in the background as opposed to retrieving data from an html
> table? If so, is there a way to convert the html table on advfn to a csv
> file to run more efficiently?
>
> Thanks for the help.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Mon Jul 30, 2012 11:52 pm (PDT) . Posted by:

"Fred Lin" FredSLin

Randy,
 
I have no problem using smfPricesByDates but RCHGetYahooQuotes seems to behave
differently. For example: =RCHGetYahooQuotes("IBM") returns literal IBM.
 
I am running win7 64b and Excel2007.
 
 
FredL

Mon Jul 30, 2012 11:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See: http://finance.groups.yahoo.com/group/smf_addin/message/19447

On Mon, Jul 30, 2012 at 11:33 PM, Fred Lin <fredslin@yahoo.com> wrote:

>
> I have no problem using smfPricesByDates but RCHGetYahooQuotes seems to
> behave
> differently. For example: =RCHGetYahooQuotes("IBM") returns literal IBM.
>
> I am running win7 64b and Excel2007.
>
>

Tue Jul 31, 2012 4:28 am (PDT) . Posted by:

"ttelip" ttelip

Hi
I'm getting errors in some elements. It seems those related with Yahoo work propery but not those ones related with MSN or others

=RCHGEtElementNumber("Source";941)=YahooKS
=RCHGEtElementNumber("Element";941)=MarketCap
=RCHGEtElementNumber("IBM";941)=224220000

But

=RCHGEtElementNumber("IBM";1541)=Error
=rchgetelementnumber(Ticker; 163)=Error

The SMF-Addin is in C:\SMF Add-in
I'm running Windows 7, spanish, excel 2007 and I've changed regional settings from X.XXX,00 (Spanish) to X,XXX.00(English)

My version is
Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-in; 34)

I've searched by the forum but similar problems were caused by not having the smfxxx.txt files in the same directory or having two smf_XXXXX.xla in diferent places. This is not my case.
Any suggestion?
Best Regards and many thanks for your help

Tue Jul 31, 2012 4:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

See: http://finance.groups.yahoo.com/group/smf_addin/message/19499

On Tue, Jul 31, 2012 at 4:27 AM, ttelip <felipeporcel@gmail.com> wrote:

> Hi
> I'm getting errors in some elements. It seems those related with Yahoo
> work propery but not those ones related with MSN or others
>
> =RCHGEtElementNumber("Source";941)=YahooKS
> =RCHGEtElementNumber("Element";941)=MarketCap
> =RCHGEtElementNumber("IBM";941)=224220000
>
> But
>
> =RCHGEtElementNumber("IBM";1541)=Error
> =rchgetelementnumber(Ticker; 163)=Error
>
> The SMF-Addin is in C:\SMF Add-in
> I'm running Windows 7, spanish, excel 2007 and I've changed regional
> settings from X.XXX,00 (Spanish) to X,XXX.00(English)
>
> My version is
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-in; 34)
>
> I've searched by the forum but similar problems were caused by not having
> the smfxxx.txt files in the same directory or having two smf_XXXXX.xla in
> diferent places. This is not my case.
> Any suggestion?
> Best Regards and many thanks for your help
>
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 04.54 0 komentar
Langganan: Postingan (Atom)