XMLGetFundimentalData

[BKST0000111]

I can successfully call the new method XLMGetFundimentalData as

XLMGetFundimentalData "IBM", 9, 0

To try to get the Exchange for IBM, but don't know what event returns my results. Where can I find the current documentation on the usage of this method? (version 7.8)

If you have a sample VB program that retrieves the fundamental info, that would be wonderful.

Dab

[Guest]

The flags the the XMLGetFundamentalData function are described in "7.7 Features", which is located in the File Share.

[BKST0000111]

Not much help

I looked this up and it does show the values but the usage is lacking and there are no examples at all. Can anyone help me with this?

[wscully]

A code snippet from VB.NET


All = IESignal.fundamentalTypeFlags.ftfCUSIP + IESignal.fundamentalTypeFlags.ftfEPS + IESignal.fundamentalTypeFlags.ftfDIVIDEND + IESignal.fundamentalTypeFlags.ftfNAME
All = All + IESignal.fundamentalTypeFlags.ftfDIVINT '+ IESignal.fundamentalTypeFlags.ftf52WLOW + IESignal.fundamentalTypeFlags.ftf52WHIGH
All = All + IESignal.fundamentalTypeFlags.ftfOPENINT + IESignal.fundamentalTypeFlags.ftfPE
All = All + IESignal.fundamentalTypeFlags.ftfSIC + IESignal.fundamentalTypeFlags.ftfXDATE + IESignal.fundamentalTypeFlags.ftfYIELD

sXMLStockDoc = esignal.XMLGetFundamentalData(txtIBDSymbol.Text, All, Nothing) 'get stock data
XMLStockDoc.LoadXml(sXMLStockDoc)
node = XMLStockDoc.DocumentElement
For Each node In XMLStockDoc.DocumentElement.ChildNodes
Select Case node.Name
Case "Dividend"

[wscully]

I should have mentioned to be careful to note that some of the code in the line that references ftf52WLOW and ftf52WHIGH is commented out because the XML data (node label) that is returned is invalid because it begins with "5". So, I cannot get the 52 week high and low using XML.


A code snippet from VB.NET


All = IESignal.fundamentalTypeFlags.ftfCUSIP + IESignal.fundamentalTypeFlags.ftfEPS + IESignal.fundamentalTypeFlags.ftfDIVIDEND + IESignal.fundamentalTypeFlags.ftfNAME
All = All + IESignal.fundamentalTypeFlags.ftfDIVINT '+ IESignal.fundamentalTypeFlags.ftf52WLOW + IESignal.fundamentalTypeFlags.ftf52WHIGH
All = All + IESignal.fundamentalTypeFlags.ftfOPENINT + IESignal.fundamentalTypeFlags.ftfPE
All = All + IESignal.fundamentalTypeFlags.ftfSIC + IESignal.fundamentalTypeFlags.ftfXDATE + IESignal.fundamentalTypeFlags.ftfYIELD

sXMLStockDoc = esignal.XMLGetFundamentalData(txtIBDSymbol.Text, All, Nothing) 'get stock data
XMLStockDoc.LoadXml(sXMLStockDoc)
node = XMLStockDoc.DocumentElement
For Each node In XMLStockDoc.DocumentElement.ChildNodes
Select Case node.Name
Case "Dividend"

[BKST0000111]

I'm doing Someting Wrong

When I use the IESignal.fundamentalTypeFlags.ftfLISTEXG, I get the message "Compiler error: Method or data member not found" on that line. When I use the value (9) I get an empty xml node back "<FundamentalQuote></FundamentalQuote>". Even when I request ALL (255) I get the same results. Here is the code. Help!

Dim sXLMStockDoc As String
Dim lReturn As Long
MsgBox iesignal.fundamentalTypeFlags.ftfLISTEXG
sXLMStockDoc = ESignal.XMLGetFundamentalData("IBM", 255, lReturn)

[BKST0000111]

Still no Joy

I made some changes but still get an empty xml structure returned.

Dim sSymbol As String
Dim sXMLStockDoc As String
Dim XMLStockDoc As MSXML.DOMDocument
Set XMLStockDoc = New MSXML.DOMDocument
Dim fFlag As iesignal.fundamentalTypeFlags
Dim node As MSXML.IXMLDOMNode
Dim lReturn As Long
lReturn = 0
fFlag = ftfLISTEXG
sSymbol = "IBM"
sXMLStockDoc = ESignal.XMLGetFundamentalData(sSymbol, fFlag, lReturn)
XMLStockDoc.validateOnParse = False
XMLStockDoc.Load (sXMLStockDoc)
For Each node In XMLStockDoc.childNodes
MsgBox node.parentNode.nodeName & " : " & node.nodeValue
Next node

[BKST0000111]

Got Something

I made no more changes but started receiving data. See the results from my IBM query

<FundamentalQuote>
<ExchangeListed>NYSEooB[1]&lf;ÕÓ+-+-W@@T@p2ËïA</ExchangeListed>
</FundamentalQuote>

Is this a valid return?

[BKST0000111]

Closer to solution

When I open a layout that has the symbols loaded that I request fundamental information on, I get return data. When I just start the application, I do not. What do I need to do so that the symbol is loaded/released?


Dim sSymbol As String
Dim sXMLStockDoc As String
Dim XMLStockDoc As MSXML.DOMDocument
Set XMLStockDoc = New MSXML.DOMDocument
Dim fFlag As iesignal.fundamentalTypeFlags
Dim node As MSXML.IXMLDOMNode
Dim lReturn As Long

lReturn = 0
fFlag = ftfLISTEXG
sSymbol = "IBM"

ESignal.DoSymbolLink sSymbol

sXMLStockDoc = ESignal.XMLGetFundamentalData(sSymbol, fFlag, lReturn)
XMLStockDoc.validateOnParse = False
XMLStockDoc.Load (sXMLStockDoc)
For Each node In XMLStockDoc.childNodes
MsgBox node.parentNode.nodeName & " : " & node.nodeValue
Next node

ESignal.ReleaseSymbol sSymbol

[Guest]

Interesting find. I will need to take to look at this in more detail. For the time being, you can just do a RequestSymbol, which will load it into the Data Manager. I am assuming this is the same function that opening a layout is doing.

[BKST0000111]

Need Exchange Cross-Ref to codes received

Here is a list of the exchanges I have after updating my entier database. I need to know what the lower case letter following the exchange is (e.g.) AMEXi. Is there a list of valid exchange values I can expect to receive. Is there a description of how you put toghter the return value for the ListExchange from the Fundanental Database?

AMEXi
AMEXn
AMEXo
AMEXp
BB
NASDm
NASDn
NASDo
NASDp
NYSEi
NYSEn
NYSEo
NYSEp
OT




<<It could be that the symbol trades on a regional exchange. O = OPRA. The listed exchange is primary exchange.

A AMEX American Stock Exchange
B BSE Boston Stock Exchange
C CSE Cincinnati Stock Exchange
M MSE Midwest (Chicago) Stock Exchange
N NYSE New York Stock Exchange
P PSE Pacific Stock Exchange
T THRD Third Party (listed stocks on the OTC market)
X PHIL Philadelphia Stock Exchange>>

[DionLoy]

That's a bug. I apologize. Only the first four letters of the ExchangeListed field should be processed. This will be patched up in 7.9. Sorry about that.

[BKST0000111]

Thanks

Dion:

Thanks, that's an easy one to work around on my end.

Would it be possible for someone to post all the possible values of the ListExchange and their meaning?

[Guest]

Here you go:

http://www.esignalcentral.com/support/symbol/symbol_format.asp

[BKST0000111]

Thanks

Codes I received that are not listed are "BB" and "OT". Are these Bulletin Board and Other?