That's a very vague question.What about the S&P 500? Current price? Historical quotes? P/E ratio? Constituents? Or something else?Index or ETF?What context? One data item, or other data and other tickers?A couple examples of last price of the index:=smfStrExtr(RCHGetWebData("https://finance.yahoo.com/quote/^GSPC","""regularMarketPrice"":",100),"""raw"":",",",1)=smfStrExtr(RCHGetWebData("https://www.barchart.com/stocks/quotes/$SPX/overview","""lastPrice"":",100),":""","""",1)On Fri, Feb 28, 2020 at 1:44 PM Leo Bueno Leo@... wrote: I will appreciate seeing the formula for the S&P 500. If possible would like to see formulas...
Jumat, 28 Februari 2020
[smf_addin] Formula for S&P 500
I will appreciate seeing the formula for the S&P 500. If possible would like to see formulas for 2 or 3 data sources (Yahoo, Google, etc.) Thanks. Leo ========= Leo Bueno ========= __._,_.___ Posted by: Leo Bueno <leo@buenolaw.com> Reply via web post • Reply to sender • ...
Kamis, 27 Februari 2020
]] XL-mania [[ 18 Confusing Pictures
18 Confusing Pictures you need to look at twice to believeClick here to see more ... __._,_.___ Posted by: alka soni <alk.asoni@yahoo.com> Reply via web post • Reply to sender • Reply to group • Start a New Topic ...
]] XL-mania [[ 18 Confusing Pictures
18 Confusing Pictures you need to look at twice to believeClick Here to see 17 more.... __._,_.___ Posted by: "shaliniratnu@yahoo.com" <shaliniratnu@yahoo.com> Reply via web post • Reply to sender • Reply to group • Start a New Topic • ...
Re: [belajar-excel] Macro Capslock On
pakai vba, dan pakai winapi ya...1. disebuah module general, copas script ini :Private Type ByteKeyboard arrKBD(0 To 255) As ByteEnd Type#If VBA7 Then Private Declare PtrSafe Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Long Private Declare PtrSafe Function GetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long Private Declare PtrSafe Function SetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long#Else Private Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Long Private Declare Function GetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long ...
Rabu, 26 Februari 2020
[belajar-excel] Macro Capslock On
Suhu Excel,Mohon bantuannya untuk macro excel auto on capslockThanks __._,_.___ Posted by: Andrie - <sioean2@yahoo.com> Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)...
Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)
Dear Ari;tetapi jumlah isian data validation masih menampilkan semua 14 baris record .. 14 baris record karena ini: +ROW($1:$14)Coba ganti rumus +ROW($1:$14) sesuai keinginan.Wassalam Bagus Pada tanggal Kam, 27 Feb 2020 pukul 09.27 Eira I Arie cheivory_bridge@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Yth.. BagasTerima kasih atas solusinya ..satu lagi pertanyaan :rumus tersebut saya tambahi iferror untuk menghilangkan error jika data kosong (juga saya set excel table) ..tetapi jumlah isian data validation masih menampilkan semua 14 baris record ..saya sudah...
Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)
Yth. BagasTerima kasih atas solusinya ..satu lagi pertanyaan :rumus tersebut saya tambahi iferror untuk menghilangkan error jika data kosong (juga saya set excel table) ..tetapi jumlah isian data validation masih menampilkan semua 14 baris record ..saya sudah mencoba membuat name range dinamis pakai offset (utk sumber bagi data validation) tetapi item yang kosong masih ikut di data validationnya ..bagaimana kira2 solusinya ?terima kasih On Thursday, February 27, 2020, 07:46:57 AM GMT+7, Bagus bagus4bls@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: ...
Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)
Dear Ari;Apakah spt file terlampir.Wassalam Bagus Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie cheivory_bridge@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Selamat Pagi Rekan2Mohon bantuannyabagaiamana cara menampilkan ID data yang belum diinput (dengan data validation) ..file kasus terlampir.terima kasihari __._,_.___ Posted by: Bagus <bagus4bls@gmail.com> ...
Selasa, 25 Februari 2020
Re: ]] XL-mania [[ Unsubscribes
Unsubscribes Get BlueMail for Android On Feb 26, 2020, at 10:40, "joko santoso j_santoso1982@yahoo.com [XL-mania]" <xl-mania@yahoogroups.com> wrote: Unsubscribes __._,_.___ Posted by: Dhim <levinstain@yahoo.co.id> Reply via web post • Reply to sender • Reply to group...
]] XL-mania [[ Unsubscribes
Unsubscribes __._,_.___ Posted by: joko santoso <j_santoso1982@yahoo.com> Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (9) ...
Langganan:
Postingan (Atom)