Jumat, 18 September 2015

[smf_addin] Digest Number 3515

8 Messages

Digest #3515
1a
1b
Re: Conference Event Dates by "Randy Harmelink" rharmelink
1c
2
Trouble with options quotes by "tony estep" tonyestep
3b
Re: Trouble with option quote by "Randy Harmelink" rharmelink

Messages

Thu Sep 17, 2015 6:14 am (PDT) . Posted by:

friedman_steve

Randy, below is a copy of what comes out when type in link (if logged in).
Are you able to figure out from this?
Or can you guide me how to determine what formula would look like?







LivePerson (LPSN) SECTOR: Information Technology | INDUSTRY: Internet Software & Services


TICKER KEYWORD
CLICK TO ADD LPSN TO A PORTFOLIO
LIVE IN PLAY
UPGRADES/DOWNGRADES
EARNINGS
GUIDANCE
EVENTS
IPO
SAME STORE SALES
SPLITS


FUTURE EVENTS Date
Page
Event
Add Event 04-Nov-15
Earnings
Next earnings release: Nov 4 after market, unconfirmed.
Capital IQ EPS consensus: 0.03
Capital IQ Rev consensus: 61.04 mln

17-Sep-15
Conferences
Deutsche Bank 2015 Technology Conference (LPSN)
16-Sep-15
Conferences
Credit Suisse 6th Annual Small and Mid Cap Conference (SMID) Conference (LPSN)



EVENTS



Start Date
End Date
Event
Ticker 16-Sep-15
18-Sep-15
Deutsche Bank 2015 Technology Conference http://mmm.wallstreethorizon.com/u.asp?u=101356
AKAM, ASML, HPY, EPAY, GPRO, MXIM, FIT, CHKP, IPHI, SEDG, FNSR, MXL, XXIA, MSFT, SANM, ON, YELP, FTNT, ADS, AIXG, AMAT, AMBA, AMS, ANET, ASGN, AVT, BABA, BHE, BLOX, BNFT, BOX, BV, CARB, CAVM, CDNS, CEB, CIEN, COMM, COUP, CRTO, CSCO, CSGP, CSOD, CTCT, CTSH, CY, CYBR, DASTY.PK, DATA, DB, DWRE, EFX, EGHT, EVTC, EXPE, FENG, FEYE, FLEX, FLTX, FN, GWRE, HAWK, HDP, HURN, IMPV, ISIL, JNPR, KEYS, KLAC, LOCK, LOGM, LOPE,LPSN, LXFT, MANH, MCHX, MDSO, MELI, MMYT, MOBL, MODN, MPWR, MRIN, MRKT, MSCC, MU, MXPT, NMBL, NOW 16-Sep-15
17-Sep-15
Credit Suisse 6th Annual Small and Mid Cap Conference (SMID) Conference http://mmm.wallstreethorizon.com/u.asp?u=95190
RSTI, TTI, OSIS, PBH, BCEI, RCAP, TREX, FISI, CALD, RENT, EGL, COWN, IRBT, FBP, ORIT, AHS, FNSR, CCMP, BOFI, MKSI, AEIS, AEL, ALOG, APIC, APPF, AVG, BBG, BDSI, BGG, BGS, BHLB, BKU, BSET, CACI, CBF, CBPX, CBU, CMLS, CNO, CNS, COMM, CSGS, CTB, CTCT, CY, DK, DPLO, DRII, DW, DXPE, ECPG, EFII, ELGX, ELLI, ENOC, ENV, FET, FIX, FLTX, GB, GCAP, GHL, GPRE, GRBK, HAYN, HCSG, HF, IDCC, IGT, IL, INDB, INT, IPCM, ITG, KAR, KFRC, LABL, LCI, LDRH, LF, LOGM, LPSN, MCRI, MFRM, MINI, MNRO, MTDR, MTZ, NCS, NEWM, NR, NTCT, NX,




Read more: In Play Log In http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb

http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb

In Play Log In http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb


View on www.briefing.com http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb
Preview by Yahoo








Thu Sep 17, 2015 6:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

These might work:

=RCHGetHTMLTable(...URL...,">Future Events",1,"",1)

=RCHGetHTMLTable(...URL...,">End Date",-1,"",1)

On Thu, Sep 17, 2015 at 6:11 AM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy,
> below is a copy of what comes out when type in link (if logged in).
> Are you able to figure out from this?
> Or can you guide me how to determine what formula would look like?
>
>
>
>
> LivePerson (LPSN) SECTOR: Information Technology | INDUSTRY: Internet
> Software & Services
> TICKER KEYWORD
> CLICK TO ADD LPSN TO A PORTFOLIO
>
> - LIVE IN PLAY
> - UPGRADES/DOWNGRADES
> - EARNINGS
> - GUIDANCE
> - EVENTS
> - IPO
> - SAME STORE SALES
> - SPLITS
> -
>
> FUTURE EVENTS
> Date
> Page
> Event
> Add Event
> 04-Nov-15
> Earnings
> Next earnings release: Nov 4 after market, unconfirmed.
> Capital IQ EPS consensus: 0.03
> Capital IQ Rev consensus: 61.04 mln
> 17-Sep-15
> Conferences
> Deutsche Bank 2015 Technology Conference (LPSN)
> [image: Add Events]
> 16-Sep-15
> Conferences
> Credit Suisse 6th Annual Small and Mid Cap Conference (SMID) Conference (
> LPSN)
> [image: Add Events]
> EVENTS
> Start Date
> End Date
> Event
> Ticker
> 16-Sep-15
> 18-Sep-15
> Deutsche Bank 2015 Technology Conference
> <http://mmm.wallstreethorizon.com/u.asp?u=101356>
> AKAM, ASML, HPY, EPAY, GPRO, MXIM, FIT, CHKP, IPHI, SEDG, FNSR, MXL, XXIA,
> MSFT, SANM, ON, YELP, FTNT, ADS, AIXG, AMAT, AMBA, AMS, ANET, ASGN, AVT,
> BABA, BHE, BLOX, BNFT, BOX, BV, CARB, CAVM, CDNS, CEB, CIEN, COMM, COUP,
> CRTO, CSCO, CSGP, CSOD, CTCT, CTSH, CY, CYBR, DASTY.PK, DATA, DB, DWRE,
> EFX, EGHT, EVTC, EXPE, FENG, FEYE, FLEX, FLTX, FN, GWRE, HAWK, HDP, HURN,
> IMPV, ISIL, JNPR, KEYS, KLAC, LOCK, LOGM, LOPE,LPSN, LXFT, MANH, MCHX,
> MDSO, MELI, MMYT, MOBL, MODN, MPWR, MRIN, MRKT, MSCC, MU, MXPT, NMBL, NOW
> 16-Sep-15
> 17-Sep-15
> Credit Suisse 6th Annual Small and Mid Cap Conference (SMID) Conference
> <http://mmm.wallstreethorizon.com/u.asp?u=95190>
> RSTI, TTI, OSIS, PBH, BCEI, RCAP, TREX, FISI, CALD, RENT, EGL, COWN, IRBT,
> FBP, ORIT, AHS, FNSR, CCMP, BOFI, MKSI, AEIS, AEL, ALOG, APIC, APPF, AVG,
> BBG, BDSI, BGG, BGS, BHLB, BKU, BSET, CACI, CBF, CBPX, CBU, CMLS, CNO, CNS,
> COMM, CSGS, CTB, CTCT, CY, DK, DPLO, DRII, DW, DXPE, ECPG, EFII, ELGX,
> ELLI, ENOC, ENV, FET, FIX, FLTX, GB, GCAP, GHL, GPRE, GRBK, HAYN, HCSG, HF,
> IDCC, IGT, IL, INDB, INT, IPCM, ITG, KAR, KFRC, LABL, LCI, LDRH, LF, LOGM,
> LPSN, MCRI, MFRM, MINI, MNRO, MTDR, MTZ, NCS, NEWM, NR, NTCT, NX,
>
>
> Read more: In Play Log In
> <http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb>
> [image: image]
> <http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb>
> In Play Log In
> <http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb>
> View on www.briefing.com
> <http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn&page=Events#ixzz3m07wxiwb>
> Preview by Yahoo
>

Thu Sep 17, 2015 9:22 am (PDT) . Posted by:

friedman_steve

can't get this to work - Briefing keeps wanting me to login again.

But, might have found workaround. By grabbing a big table of all events, and copy/paste it into excel... and then I can just use VLOOKUP to find the spot in table that has the event.


Only catch....the table lists ALL the company tickers for a conference in one cell (for example: PACB, NVS, PHG, INFI, WAT, SVA, CBPO, OPHT, CYH, ...)
When i do vlookup using "*" before and after the ticker.......it works (EXCEPT it stops working if more than around 250 characters in the cell)..... perhaps some sort of Excel limitation. So i'm stuck again :(

=VLOOKUP("*nvro*",$J$10:$Q$3400,5,TRUE)



Thu Sep 17, 2015 9:01 am (PDT) . Posted by:

"tony estep" tonyestep

I love this add-in! All was going well until I tried to query for options prices, using the sample strings in the Docs. I can get a header, but the price fields just show Error. I tried smfGetOptionQuotes as well as the smfGetYahooOptionQuote, but I can't get either to work. In the case of the Yahoo function, the sample string refers to an option that still exists, so I pasted it directly but just got Error.
Examples of options I'm trying to price: VIX Oct 21 2015 22 Calls, QQQ Oct 16 2015 107 Puts.
Any help would be immensely appreciated. Thanks much,
Tony Estep

Thu Sep 17, 2015 9:06 am (PDT) . Posted by:

tonyestep

I am trying to get quotes on options, adapting the sample query strings in the documentation, but so far no joy. My add-in is working okay, because I get stock prices, and the options string will return a header, but just Error where the price info is supposed to be.


Here are a couple of examples of options I'm looking for: VIX Oct 21 Calls at 22, GLD Oct 16 Puts at 105. I'm sure it's something simple and stupid but I am out of ideas. Thanks to anyone who can help!


Tony Estep

Thu Sep 17, 2015 9:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Both of these work fine for me:

=smfGetOptionQuotes("VIX 10/21 2015 $22 Call","b")
=smfGetOptionQuotes("GLD 10/16 2015 $105 Put","b")

...but you may need the beta version of the add-in from the "Works in
Progress" folder. A lot of changes have been made to options quotes
processing since the last official release of the add-in.

On Thu, Sep 17, 2015 at 9:06 AM, tonyestep@... wrote:

> I am trying to get quotes on options, adapting the sample query strings in
> the documentation, but so far no joy. My add-in is working okay, because I
> get stock prices, and the options string will return a header, but just
> Error where the price info is supposed to be.
>
> Here are a couple of examples of options I'm looking for: VIX Oct 21 Calls
> at 22, GLD Oct 16 Puts at 105. I'm sure it's something simple and stupid
> but I am out of ideas. Thanks to anyone who can help!
>
>

Thu Sep 17, 2015 1:48 pm (PDT) . Posted by:

tonyestep

Great, Randy, thanks so much. I didn't see your reply before I posted my question about the Yahoo version. The string in your reply appears to work!

Thanks again,
Tony Estep

Thu Sep 17, 2015 1:42 pm (PDT) . Posted by:

"tony estep" tonyestep

I posted earlier that I couldn't get anything except Error from my attempts to retrieve options prices. I tried various approaches, and finally the smfGetYahooOptionQuote did indeed return prices. I was overjoyed -- but it didn't last long, because the prices aren't correct. It's not that they're stale; it's as if they are coming from some completely wrong source. 
For example, the QQQ 107 Puts 10/16/15 are selling at this moment at 263. They have traded between 250 and 270 today. But my smf function returns a Last sale of 1.82. I have checked and re-checked my call to the function, and I think it's correct. Anybody have any words of wisdom??
Thanks,Tony Estep
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.57

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)