jessejjchen / yahoo-finance-managed Goto Github PK

Creating a version of Yahoo! Finance Managed for PocketPCs (WM5/CF2).

Objective: Downloading finance data on smart devices

Add ISO Code to Countries MarketData to interop with other libraries/systems

Add missing countries referenced in exchanges definitions 

[Argentina]
[Venezuela]
[Indonesia]
[Malaysia]
[Peru]
[Sweden]
[Thailand]
[Chile]
[Taiwan]

with the latest version (0.11) if you try with "URRE" (Uranium Resources, 
Inc.), the result is empty.

I've digged a bit, and the problem is this line (291, in ConvertResult funct):

 if (res != null && (res.CompanyName == string.Empty || res.Address == string.Empty || res.BusinessSummary.StartsWith("There is no "))) { res = null; }

Actually, there's no address in the res var and for that reason res is null...

1) there's a parse error in the address part
2) why you nullify the entire result is some information are missing? (maybe 
you can "EnablePartialResult" in the settings ...


Yahoo Profile link: http://finance.yahoo.com/q/pr?s=urre

rgds /// Angel

What steps will reproduce the problem?
1.I want to use the MaasOne.YahooManaged.dll and the MaasOne.Base.dll in a 
Windows Phone 7 project.
2.A error:"Reference cannot be added to ****\MaasOne.Base.dll beause it was not 
built using the windows Phone runtime."
3.

What is the expected output? What do you see instead?
I want to use it in the Windows Phone 7 project,thanks!


Do you have other informations?



Suggestions to fix the defect?

I started looking into your Yahoo managed library but I quickly ran into an 
issue where the library is not strong named and cannot be referenced by our 
strongly named application.

Can strong naming be added?
http://msdn.microsoft.com/en-us/library/ms247123(v=VS.100).aspx

Yahoo! provides an ID search/lookup for every supported stock, index, 
funds, etc.
A must-be for this library.

do to the new currency: 
    <Currency Name="Cape Verde Excudo" ID="CVE" />

in the demo app, the EURO should inserted in index 38, not 37:
                Dim eur As New CurrencyInfo("EUR", "Euro")
                Dim exr As New Support.ExchangeRateData(eur, eur, New QuoteBaseData("EUREUR=X") With {.LastTradePriceOnly = 1})
                Dim items = mCalculator.ExchangeItems.ToList
                items.Insert(37, exr)
                mCalculator.ExchangeItems = items.ToArray
                Dim dt = Support.ExchangeRateCalculator.CrossDataTable(mCalculator.ExchangeItems, "Cur")
file: ExchangerateCtr.xaml.vb

Angelo

my code is as following , it sometimes return 13 records, sometimes return 3 
records, why? is there any mistake I have made?

 Dim hqdl As New API.HistQuotesDownload
 Dim resp As API.HistQuotesResponse = _
         hqdl.Download("0455.hk", #7/9/2011#, Date.Today,HistQuotesInterval.Daily)
        For Each hqdc As HistQuotesDataChain In resp.Result
            For Each hqd As HistQuoteData In hqdc
                Debug.Write(hqd.TradingDate.ToShortDateString & ";")
                Debug.Write(hqd.Open.ToString("n") & ";")
                Debug.Write(hqd.Close.ToString("n") & ";")
                Debug.WriteLine(hqd.CloseAdjusted.ToString("n"))

            Next
            Debug.WriteLine("----------------------")
        Next

MarketResult
CompanyInfoResult
IndustryResult
MarketQuotesResult
QuoteOptionsResult
BondScreenerResult
StockScreenerResult

get { return Items; } --> get { return mItems; }

regards /// Angel

CountryInfo.ID at WorldMarket.GetDefaultIndices

All Ids are USA

WorldMarket.vb line 170 

"If c.ToString = cntType Then"  cntType instead of curStr

Hello,
Recently the LastTradePriceOnly value retrieved via QuotesDownload is getting 
invalid values assigned during calls. Example, every 3rd or 5th call for a 
quote for symbol MSFT gets a value like 505545800.00. This happens with NYSE 
and Nasdaq quotes and only started occurring last week. I'm trying this via the 
.net libary and also tried the latest uploaded dlls.


What is the expected output? What do you see instead?
A valid quote for LastTradePriceOnly such as 27.05 instead of a value like 
505545800.00. This happens intermittently.

There's a bug in this class:

    /// <summary>
    /// Provides connection information and downloaded company data.
    /// </summary>
    /// <remarks></remarks>
    public class CompanyInfoResult
    {
        private CompanyInfoData[] mItems = null;
        public CompanyInfoData[] Items
        {
            get { return Items; } --> it should be the private member mItems
        }
        internal CompanyInfoResult(CompanyInfoData[] items)
        {
            mItems = items;
        }
    }

Regards /// Angel

In the Code below
Dim dl As New YahooManaged.Search.Diverse.API.SiteExplorerDownload
Dim resp As YahooManaged.Search.Diverse.API.SiteExplorerResponse = 
dl.DownloadInLinks(url) 

the function DownloadInLinks has two overloads either use URI as system.uri  or 
a URL of a site.
when i use URL as string It returns an Exception as formate of URI is not 
currect.
when I use URI in the parameter then i get resp.connection.status = 400 always 


What is going wrong in the code.

Hi Maas,
I've already implemented such a function some years ago (2007), and today I've 
tested and it works ... Maybe it can be re engineered and integrated into your 
library.

So basically you can search the top gainers, losers, ... to write this, I've 
used an http sniffer and watched how the java version of the Yahoo Screen 
composed the request (http://screen.finance.yahoo.com/newscreener.html).

Attached you'll find the still working function I wrote.

Let me know

Regards,
Angel

QuotesDownload
CompanyInfoDownload
...

lots of them don't return the company name (CompanyName) (try with AAPL)

regards /// Angel

YID id = new YID(res) throw 

Object reference not set to an instance of an object.

YID.ISIN initialized to null/nothing


Suggestions to fix the defect?

YID.vs line 44

"Private mISIN As New ISIN" instead of 
"Private mISIN As ISIN = Nothing"

Hello, 

Do the API use YQL or classical CSV API behind ?

regards,

David

What steps will reproduce the problem?
1.Running YahooManaged_TestApp_WPF.exe
2.I'm using .net framework 4.0

What is the expected output? What do you see instead?
The main form

Do you have other informations?
No

Suggestions to fix the defect?
Nothing

What steps will reproduce the problem?
1. Get the historic quotes and try to access QuoteProperty enum values for 
HistQuoteData

What is the expected output? What do you see instead?
1. We should be able to access QuoteProperty enum on Historic quotes


Do you have other informations?



Suggestions to fix the defect?

Hi Maas,
is it possible to you to avoid this line:

        public ISIN(string isinWithOrWithoutCheckDigit)
        {
            if (!IsValidFormatted(isinWithOrWithoutCheckDigit))
            {
                throw new ArgumentException("The ISIN value is not valid formatted.", "isinWithOrWithoutCheckDigit"); // <--
            }


infact in the IDSearchDownload will throw an exception, and you wont have 
results ...

Angel

What steps will reproduce the problem?
1.Open v.77 Test App
2.Run the WPF Test App
3.Select Yahoo in the list box
4.Click "Company Info" button
5.Look at the (bottom right) "Last Split Factor" and "Last Split Date". the 
field values seem to be switched. i.e. it is showing the split date in the 
split factor field and vice versa.

What is the expected output? What do you see instead?

What it should be:
Last Split Factor = 2 : 1
Last Split Date = 5/12/2004


What I see
Last Split Factor = 5/12/2004
Last Split Date = 2 : 1

Hi Maas,
I've found that the Quotes Download has a strange behaviour on a single ticker 
download on a non us exchange(BUL.MI -->Bulgari) and I've found that the old 
call is working (QuotesDownload.vb):

New funct:
        Private Function DownloadURL(ByVal unmanagedIDs As IEnumerable(Of String), ByVal properties() As QuoteProperty) As String
            Dim lst() As String = mHelper.EnumToArray(unmanagedIDs)
            If lst.Length > 0 Then
                Dim ids As New Text.StringBuilder
                For Each s As String In lst
                    ids.Append(mHelper.CleanYqlParam(s))
                    ids.Append("+"c)
                Next
                Return "http://download.finance.yahoo.com/d/quotes.csv?s=" & Uri.EscapeDataString(ids.ToString) & "&f=" & mFinanceHelper.CsvQuotePropertyTags(properties) & "&e=.csv"
            Else
                Throw New NotSupportedException("An empty id list will not be supported.")
            End If
        End Function

the old:
        Private Function DownloadURL(ByVal unmanagedIDs As IEnumerable(Of String), ByVal properties() As QuoteProperty, ByVal server As Server) As String
            Dim lst() As String = mHelper.EnumToArray(unmanagedIDs)
            If lst.Length > 0 Then

                If server = server.YQL Then
                    Dim fields As String = String.Empty
                    If properties Is Nothing OrElse properties.Length = 0 Then
                        fields = "*"
                    Else
                        Dim sb As New Text.StringBuilder
                        For Each p As QuoteProperty In properties
                            sb.Append(p.ToString)
                            sb.Append(",")
                        Next
                        sb.Remove(sb.Length - 1, 1)
                        fields = sb.ToString
                    End If

                    Dim whereClause As New Text.StringBuilder()
                    whereClause.Append("symbol in (")
                    For Each id As String In lst
                        whereClause.Append(""""c)
                        whereClause.Append(mHelper.CleanYqlParam(id))
                        whereClause.Append(""",")
                    Next
                    whereClause.Remove(whereClause.Length - 1, 1)
                    whereClause.Append(")"c)

                    Return mHelper.YqlUrl(fields, "yahoo.finance.quotes", whereClause.ToString, Nothing, False)

                Else
....

and if the server is the standard, the request goes to:
http://query.yahooapis.com/v1/public/yql

and not to:
http://download.finance.yahoo.com/d/quotes.csv

Regards /// Angel

There no symbol name, tested with aapl

rgds /// Angel

tried to compile the source but source files have missing codes
as many variables are deleted before upload

may be the author doesn't want to share the actual source code

files have been checked by me and have significant difference from the files 
downloaded from codeproject.com

When using YahooManaged.Search.BOSS.API.SearchDownload() Download method is get 
the following error:
The remote server returned an error: (407) Proxy Authentication Required.

This looks like it is because i am behind a web proxy which requires 
authentication.


I have tried creating my own proxy:
            string consumerKey = @"...";
            string consumerSecret = "...";
            var dl = new YahooManaged.Search.BOSS.API.SearchDownload();
            dl.UniversalOptions.HttpsUsed = false;
            dl.UniversalOptions.ConsumerKey = consumerKey;
            dl.UniversalOptions.ConsumerSecret = new System.Security.SecureString();
            WebProxy webProxy = new WebProxy("primary-proxy.mydomain.com",8181)
                                    {

                                        UseDefaultCredentials =  true,
                                    };

            dl.Proxy = webProxy;


However this resulted in Bad Request 200 error message.


Is there an example somewhere that works from behind a web proxy that requires 
authentication ?

What steps will reproduce the problem?
1.Add the wp7 dll to a windows phone 7 silver light project
2.Try to use it
3.

What is the expected output? What do you see instead?
There is no exception reported and the project should compile

Instead:
There is a warning and i am not able to use the namespace
Warning 1   The primary reference "YahooManaged7" could not be resolved because 
it has an indirect dependency on the framework assembly "Microsoft.VisualBasic, 
Version=2.0.5.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" which could 
not be resolved in the currently targeted framework. 
"Silverlight,Version=v4.0,Profile=WindowsPhone". To resolve this problem, 
either remove the reference "YahooManaged7" or retarget your application to a 
framework version which contains "Microsoft.VisualBasic, Version=2.0.5.0, 
Culture=neutral, PublicKeyToken=31bf3856ad364e35".  PhoneApp2


Do you have other informations?



Suggestions to fix the defect?

Regards,

Hi Gents,

Let me just say how impressed and excited I am regarding your Yahoo .net code 
project.  I would like to get involved if I could and wondered if you could 
help with the following.  A couple of background things…

What brought me to your site and project:
I have always been looking for code which could build a complete and thorough 
list of ALL tracked financial instruments by Yahoo regardless of type of 
instrument or country.  Your project comes very close to this, and I will try 
to work with it as best I can.



Could you help me.  Although there is a bit of a C# routine, the 
release/showcase is in VB.  Any plans to get an identical parallel project in 
C#?  Or do you have one archived?  The reason I ask is that I’m much better 
at C# than VB.

A bug or issue I noticed which you may or may not be aware of is the following, 
you can re-create the issue…
                Under the finance tab and under keyword search, I set the following…
                                Download settings          Type: Any, Markets: AllMarkets, Rankled by: ID, Rank direction: ascending, count: 10000
                                View Settings                    Enable filter on (Or) off,                Hide empty names:  on (Or) off

                The type the letter “A” in the search field.

What I see happen is that it cycles up to about 1020 results and stops even 
though it lists 184937 in the x value initially.  When the green status bar 
approaches then stops at 1020 and the line underneath  i.e., 10000  / 1849 the 
x value truncates or get corrupt?

So anyway, I’m not sure if there is a limiting factor with Yahoo or in your 
code, if I’m not doing something correct.  Ideally I wish to loop search 
strings and store all instrument lists and archive them by country to csv ASCII.

Let me know and of course how I may help the project.

Cheers – Sean

in MarketData.xml line 402

TLX/EuroTLX reference invalid country code 'Italia' 
Italy Code is 'Italy'


Suggestions to fix the defect?

<StockExchange ID="TLX" Suffix=".TI" DelayMinutes="00" 
OpeningTimeUTC="00:00:00" ClosingTimeUTC="00:00:00" RelativeHoursToUTC="0" 
Country="Italy" Name="TLX/EuroTLX" TradingDays="Mo,Tu,We,Th,Fr" Currency="EUR" 
/>

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?
Accessing the monthly historical quotes for some of the symbols using 
HistQuotesDownload. Got wrong quotes. Please see the attached code and output 
window screenshot. Quotes for SUZLON.NS and UNITECH.NS are wrong. YHOO quotes 
are not coming up in the output. Am I missing something in the code ?

Do you have other informations?



Suggestions to fix the defect?

Hi maas, I found this think a little strange, I've a regular ID for the 
industry, but the type is always nothing ...
I'll attach the images

Regards /// angel

trying to access NewsSearch however I am getting a 401 un autherised message ?

however when i query the websearch I get results back.

Do I need to grant permissions in my yahoo application in the yahoo web site ?

  var dl = new SearchDownload();
            Results = new List<IBaseSearchResult>();
            var culture = new Culture(Language.en, Country.UK);
            string queryText = "bob diamond barclays capital";
            SearchOptions = new List<SearchOptions>();

            #region searchDownload
            dl.UniversalOptions.HttpsUsed = false;
            dl.UniversalOptions.ConsumerKey = ConsumerKey;
            dl.UniversalOptions.ConsumerSecret = new System.Security.SecureString();
            foreach (char c_loopVariable in ConsumerSecret)
            {
                dl.UniversalOptions.ConsumerSecret.AppendChar(c_loopVariable);
            }
            dl.UniversalOptions.ConsumerSecret.MakeReadOnly();
            dl.Proxy = new WebProxy("app-proxy.mydomain.com", 8080) { UseDefaultCredentials = true };


 var newsSearch = new NewsSearchOptions
            {
                AlwaysLatestDateNow = true,
                Count = 10,
                //Culture = culture,
                QueryText = queryText,

            };
SearchOptions.Add(newsSearch);

The file market.xml (Finance.Support) has two identical lines:

    <Country ID="CA" Currency="CAD" Name="Canada" >
      <Indices>
        <Index Name="S&amp;P/TSX Composite Index" ID="^GSPTSE" StockExchange="TOR" />
        <Index Name="S&amp;P/TSX Composite Index" ID="^GSPTSE" StockExchange="TOR" />

this can cause a Primary Key violation if committed to db ...

Regards /// Angel

[deleted issue]

Hi, I would like to get fundamental info about companies.
Such as Trading Time, Sector, Industry, Number of Employees? Address? Website?
How did you do it? Can you please help?

Many thanks!!!!

When I set the ChartSize to Medium or Large, them ChartTimeSpan works fine, 
displaying whatever is selected.

However, when ChartSize is set to Small, then no matter what the ChartTimeSpan 
is set to, it defaults to 1 day.

Is this by design?

Thanks for a great library!

What steps will reproduce the problem?
1. Use the enclosed .CS file to attempt to download multiple option expirations 
for stock symbol.

What is the expected output? What do you see instead?
- Should display options for different months.
- Displays options for the same month, multiple times.

Do you have other informations?
- Project file attached
- First "OUTPUT" column is option symbol.
- Should change name based on option expiration.
- Ex: TLT110729xxx..., TLT110820xxx..., TLT110917...
- Using latest available yahooManaged.dll
- Running Mono 2.10.2

Suggestions to fix the defect?
- Not sure why the expiration is getting lost.

Hi Maas,
is possible for you to re-add the CrossDataTable function in?:
MassOne.Finance.YahooFinance.Support.ExchangeRAteCalculator


function:

        /// <summary>
        /// Returns a data table where every available currency is value converted to each other
        /// </summary>
        /// <param name="firstColumnName">The text in the left edge of the column header</param>
        /// <param name="items">The exchange items. Every exchange item must have the same base currency.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        public static System.Data.DataTable CrossDataTable(IEnumerable<Support.ExchangeRateData> items, string firstColumnName = "")
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            if (items != null)
            {
                dt.Columns.Add(firstColumnName, typeof(string));
                foreach (Support.ExchangeRateData curX in items)
                {
                    if (curX != null)
                        dt.Columns.Add(curX.CurrencyRelation.DepCurrency.ID, typeof(double));
                }
                foreach (Support.ExchangeRateData curY in items)
                {
                    if (curY != null)
                    {
                        System.Data.DataRow row = dt.NewRow();
                        row[0] = curY.CurrencyRelation.DepCurrency.ID;
                        foreach (Support.ExchangeRateData curX in items)
                        {
                            if (curX != null)
                                row[curX.CurrencyRelation.DepCurrency.ID] = Math.Round(Support.ExchangeRateCalculator.ConvertCurrency(1, curY, curX), 4);
                        }
                        dt.Rows.Add(row);
                    }
                }
            }
            return dt;
        }

Regards, Angel

[deleted issue]

What is the main issue of your suggestion?
I thing it's useful addiction (I needed it ...)

I've aleady modified the source code, and it works well, this is my 
implementation (add this to your base file, I've fixed german server for ISIN):

        'Modified for Sync Download
        Private mTextEncoding As System.Text.Encoding = System.Text.Encoding.UTF8

        ''' <summary>
        ''' Downloads the specified text.
        ''' </summary>
        ''' <param name="text">The text.</param>
        ''' <param name="userArgs">The user args.</param><returns></returns>
        Public Function Download(ByVal text As String, Optional ByVal userArgs As Object = Nothing) As API.IDSearchResponse
            If text.Trim = String.Empty Then Throw New ArgumentNullException("text", "The text is empty.")
            mFinished = False


            Dim dlArgs As AsyncDownloadRecursiveArgs = New AsyncDownloadRecursiveArgs(userArgs)
            dlArgs.PagesStarted += 1
            dlArgs.Text = text.Trim
            dlArgs.Options = New IDSearchOptions(mOptions)

            Dim url As String = Me.DownloadURLGer(dlArgs.Text, dlArgs.Options, dlArgs.PagesStarted)
            MyBase.DownloadStream(url)

            Return Me.ToResponse(MyBase.DownloadStream(url))

        End Function

        ''' <summary>
        ''' the response.
        ''' </summary>
        ''' <param name="resp">The resp.</param><returns></returns>
        Private Function ToResponse(ByVal resp As Base.StreamResponse) As API.IDSearchResponse
            Dim text As String = mHelper.StreamToString(resp.Result, mTextEncoding)
            Return New API.IDSearchResponse(resp.Connection, ToSearchResults(text))
        End Function
        'end modification

hope it helps
Regards /// Angelo

1. set properties to YahooManaged.Search.BOSS.API.ImageSearchOptions
2. trying to download like  Dim resp As 
YahooManaged.Search.BOSS.API.SearchResponse = dl.Download(imageSearch)


stack trace 
 MaasOne.YahooManaged.Search.BOSS.API.SearchDownload.ToBossImageSearchResult(XmlNode node) +649
   MaasOne.YahooManaged.Search.BOSS.API.SearchDownload.ToResponse(StreamResponse resp) +1049
   MaasOne.YahooManaged.Search.BOSS.API.SearchDownload.Download(IEnumerable`1 services) +177
   WebSearch.SetImagesResults(String Query, String start1, String v, Search se) in Search\WebSearch.vb:559
   WebSearch.Search(String Query, Int32 start) in Search\WebSearch.vb:250
   MailYouLikev3.Search1.getResults(String q, Int64 start, SearchType SearchType) in Search\Search.aspx.vb:203
   MailYouLikev3.Search1.Page_Load(Object sender, EventArgs e) in Search\Search.aspx.vb:92
   System.Web.UI.Control.OnLoad(EventArgs e) +131
   System.Web.UI.Control.LoadRecursive() +65
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2427

What steps will reproduce the problem?
1. Query for the currency (c4) of a non-existent symbol
2. Repeat
3.

What is the expected output? What do you see instead?
Expect empty field, get random characters, including newlines which can break 
parsing

same error as the company info, a private member should be used

    public class ChartResult { 


        private System.IO.MemoryStream mItem = null;
        public System.IO.MemoryStream Item
        {
            get { return Item; } --> mItem
        }
        internal ChartResult(System.IO.MemoryStream item)
        {
            mItem = item;
        }}


Regards /// Angel

Hi Maas, I'm testing your pre-release, and you've done a lot of changes ...
there's a small typo error in that class:

Public Class StockScreeneData
          Inherits MaasOne.Finance.YahooFinance.QuotesData
     Member of MaasOne.Finance.YahooScreener

as you can see, it shoul be: 
Public Class StockScreenerData

Regards /// Angel

how to use this class?
thanks maas

Angel

Company statistics can't download market cap, enterprise value, .... anymore. 

Hi maas, 
the standard behavior was:

'Download Industries
Dim dl As New MarketDownload
Dim respIndustries As IndustryResponse = dl.DownloadIndustries(industries)

where industries is an IEnumerable(Of Industry)

now I've got error stating that no settings was defined.

No problem, I change the previous code in:
'Download Industries
Dim dl As New MarketDownload
Dim dlSet As New MarketDownloadSettings
 dl.Settings = dlSet
Dim respIndustries As IndustryResponse = dl.DownloadIndustries(industries)

My suggestion is, when the setting is nothing, instead throwing an exception, 
you can instantiate a new one.

Regards /// Angel 

Another little bug ;):

on the GetUrl():
       protected override string GetUrl()
        {
            if (mSector.HasValue)
            {
                return "http://biz.yahoo.com/p/csv/" + (mSector.Value + 1).ToString() + FinanceHelper.MarketQuotesRankingTypeString(this.RankedBy) + FinanceHelper.MarketQuotesRankingDirectionString(this.RankDirection) + ".csv";
            }
....

should be changed in:
        protected override string GetUrl()
        {
            if (mSector.HasValue)
            {
                return "http://biz.yahoo.com/p/csv/" + ((int)mSector.Value).ToString() + FinanceHelper.MarketQuotesRankingTypeString(this.RankedBy) + FinanceHelper.MarketQuotesRankingDirectionString(this.RankDirection) + ".csv";
            }
....

The sector has to be an integer, and you do not need to add 1.
Regards /// Angel

What steps will reproduce the problem: (taking RIO.L for example)
 var csd = new CompanyStatisticsDownload();
            foreach (string sym in symbols)
            {
                CompanyStatisticResponse csr = csd.Download(sym);
                if (csr.Result != null)
                {
                    CompanyStatisticsData cs = csr.Result;
                    Console.WriteLine("Company:{0}", cs.Name);
                    Console.WriteLine("One year high = {0}", cs.TradingInfo.OneYearHigh);
                    Console.WriteLine("One year low = {0}", cs.TradingInfo.OneYearLow);
                    Console.WriteLine("% insiders = {0}", cs.TradingInfo.PercentHeldByInsiders);
                    Console.WriteLine("% institutions = {0}", cs.TradingInfo.PercentHeldByInstitutions);
                }
            }

What is the expected output? What do you see instead?
52wk Range: 2,751.00 - 4,592.0
But I see high = 0, low = 0, %insiders = 2751, %institutions = 4286

I tried adding the .dll files to the macro add ons but it says its not a valid 
excel add on. Any idea how I can use this library with with excel?

What is the main issue of your suggestion?  I would like to be able to build 
and run this App on MONO.


Why it's useful to others?  Well you have a lot of Linux and Mac users using 
Mono so I think running it would help promote the product.


Details?  None known of yet


Implementing?  Have not tried to implement it myself yet.