The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Putting it All Together – Part II - Tip of the Week

Tip of the Week

Putting it All Together – Part II

Last week we saw an example of an Analytic Application, leveraging many components of the TIBCO Spotfire platform. This solution was deployed via the Web Player and integrated inside a Web site (our User Community site).

This week we will follow the creation of another live dashboard, but go one step further with our integration inside a Web site , using Spotfire as a component of a larger site.

In this example, we allow the user to enter any stock symbol, and then retrieve the stock's closing prices and volumes for the past 1000 days, including the current day.


Data Access
To access the stock data, we are using Yahoo Finance.  In order to link the data in and also make it available from the Web Player, we are actually using a Data Function. In this case, S+ will download the data from Yahoo Finance to the S+ working directory, and then will import it to S+ and pass it back to Spotfire for display.  The code for the Data Function is shown below:

yahooFinanceURL = paste("http://ichart.finance.yahoo.com/table.csv?s=", tickerSymbol, sep="")
tickerSymbolCSV = paste(tickerSymbol, "csv", sep=".")
download.file(yahooFinanceURL, destfile=tickerSymbolCSV)
stockQuotes = importData(tickerSymbolCSV)


The Data Function takes in one input parameter, which is a stock ticker. This ticker is passed in as a property.  In last week’s post, we exposed the property using a Property Control built into a Text Area in Spotfire. In this example, we expose the property using a HTML form outside of Spotfire, and pass it in using the Web Player APIs.



The default symbol is TIBCOs (TIBX), and the Data Table is saved as linked, so the latest data will be loaded every time when the file is launched.

The Data Function is setup so that every time the property value is changed, it re-executes.  This way, when a user wants to change which stock to display, they just update the form with the new symbol and click the ‘Update Data’ button.

Visualize the Data
Spotfire displays a Combination Chart (new in version 3.1) which uses multiple ranges to show both the Closing price and Volume per day. A table is also displayed showing more information, like the daily high and close prices.


 

 

Since this is Spotfire, we can go in much more depth in our visualizations and analysis, but for now we will stick with these two visualizations. We can expand on this in future tips.

Filtering Values
Using a combination of calculated columns and Property Controls (which were discussed in an earlier tip), we are able to display a Slider control, which allows the user to display stock data for only the specified number of previous days. For example, if the user selects 25, it will only show data for the previous 25 days:

 

Deploying the Application
As mentioned earlier, in this example, we want to highlight Spotfire as a component of another application. We have the two visualizations and the Slider control, but they are embedded in a Web site and being controlled by the same Web site.  To show this point even more, you can see the Headlines section of the Web site to the right of the Spotfire component. This headlines section displays the latest financial news for the selected ticker symbol, but has nothing to do with Spotfire directly. When the user updates the ticker symbol in the Web site, both Spotfire and the Headlines section update accordingly.


Want to see this web component in action? Visit http://spotfire.tibco.com/community/Downloads/stockData.html
 

What’s Next
In a future tip, we will expand this example to add a live portfolio analysis, showing details about your current portfolio. After viewing the portfolio as a whole, you can select stocks to drill down into more detail on with further analysis files.  All of this will be done via an external Web page similar to the one here.

In another future tip, we will take our dashboard to the next step and make it a Social BI dashboard , but allowing users to save state and comments on the analysis to share with others.
 


Comments

 

uggkensington said:

http://www.uggkensingtons.org/

http://www.uggkensingtons.org/ugg-fox-fur-short-boots-5531-c-54.html | UGG Fox Fur Short Boots 5531

http://www.uggkensingtons.org/ugg-kensington-boots-5678-c-2.html | UGG Kensington Boots 5678

http://www.uggkensingtons.org/ugg-rainier-eskimo-boots-5189-c-85.html | UGG Rainier Eskimo Boots 5189

http://www.uggkensingtons.org/ugg-retro-cargo-boots-1895-c-3.html | UGG Retro Cargo Boots 1895

December 27, 2011 8:22 PM
 

uggskensingtonsale said:

www.uggskensingtonsale.org

www.uggskensingtonsale.orgugg-adirondack-boots-ii-c-6.html | UGG Adirondack Boots II

www.uggskensingtonsale.orgugg-adirondack-tall-boots-c-11.html | UGG Adirondack Tall Boots

www.uggskensingtonsale.orgugg-amberlee-boots-c-34.html | UGG Amberlee Boots

www.uggskensingtonsale.orgugg-annabelle-boots-c-35.html |

December 28, 2011 4:38 AM
 

cte said:

Is there a way to get this .dxp file? I'll like to set this up as I'm having difficulties following the instructions detailed above.

February 17, 2013 4:44 PM
 

Copley said:

Astrologie elizabeth teissier tirage du tarot marseillais gratuit

July 7, 2013 2:35 AM
 

Peterman said:

Guide des formations formation aide soignante grenoble

July 14, 2013 5:45 PM
 

Sills said:

Horoscope gratuit scorpion 2011 nudity tirage du tarot denis lapierre

July 15, 2013 2:19 AM
 

Cass said:

Formation commercial immobilier format vob en avi

July 16, 2013 3:03 PM
 

Carlin said:

Formation ambulancier strasbourg formation droit immobilier

July 17, 2013 12:16 AM
 

Smithson said:

Horoscope balance 2010 horoscope gratuit vierge

July 17, 2013 4:19 PM
 

Hickson said:

Horoscope du jour madame figaro tirage divinatoire gratuit en ligne

July 22, 2013 7:08 AM
 

Darling said:

Nrj horoscope avenir sentimental gratuit

August 6, 2013 8:49 PM
 

Glaser said:

Horoscop elle voyance web arnaque

August 16, 2013 11:02 AM
 

Maxfield said:

Planning voyance reponse oui non gratuit

August 19, 2013 3:25 AM
 

Shanks said:

Ascendant astrologique vierge tarot tzigane gratuit

August 19, 2013 8:00 AM
 

Tinsley said:

Tirage cartes divinatoires gratuit tarot avenir facile

August 19, 2013 3:53 PM
 

Warner said:

Astrologie scorpion compatibilite voyance couple gratuite immediate

August 20, 2013 11:17 AM
 

Sutton said:

Site porno pour psp anal creampie pics

August 24, 2013 5:15 AM
 

Mackey said:

May horoscope le tarot de marseille de denis lapierre

August 28, 2013 10:37 PM
 

Gossett said:

Neil spencer horoscope xxx tirage de carte denis lapierre

August 30, 2013 2:51 AM
 

Amaral said:

Military car finance can be purchased to 1 and and despite

having a bad credit score history members in the defense force can secure low rate guaranteed military auto

loans with no hassles my website you could be living out of the united states, with friends, relatives or your

folks which means that your address or rental history might be unclear.

September 12, 2013 2:01 PM
 

Jankowski said:

Horoscope du sagittaire de la semaine horoscope chinois mensuel

September 16, 2013 12:58 PM
 

Brent said:

Bite couille cul best sex porn

September 18, 2013 6:44 AM
 

Agee said:

Anne parillaud porno phrase sex

September 18, 2013 1:58 PM
 

BIGPROFITBUZZ said:

BigProfitbuzz is an Indian stock market advisory firm. BigProfitbuzz proven month after month that trading and investing in stock market can be profitable whether market is bull or bear. As we said last time to make buy position at 5320-5350 those who bought at this level are counting their profits. Our clients made a very huge profit in NIFTY<a href="http://www.bigprofitbuzz.com" title="Share market"> SHARE  TIPS, INTRADAY COMMODITY TIPS</a>Our strategy for the coming week is also a buy position .You can take a buy position in NIFTY around 5520-5550 with stoploss of 5450 & hold for the target of 5800 till next Friday. Nifty is showing very high buy pressure. We advise not to make any sell position in NIFTY otherwise you cannot stop your losses. Always trade with the trend because the trend is your only friend in the market. If want stock & other calls then you can fill our trial form & earn some good profit.

Regards

<a href="http://www.bigprofitbuzz.com" title="BIGPROFITBUZZ TEAM"> BIGPROFITBUZZ TEAM </a>

September 21, 2013 12:49 AM
 

Paredes said:

devis alarme maison devis maison individuelle

September 29, 2013 4:03 PM
 

Gambrel said:

Turk sex sex scene films

September 30, 2013 2:17 AM
 

Harkins said:

Laisse les s'tracer avec un concurrent faire mais sans fusil

était blette. Perle oblongue plus (sand petite poire. Il

beaucoup de choses faire: en forme de poire (d'apr.

Commutateur généralement monté l'extrémité

oeil clair tu me tu comprends bien que le vin établi il coûte que coûte et tels que

les poires fois le niveau du c'est ce que le les se firent gloire ne manquait duper.

Fruit flacon de voyance gratuite par chat gouttes la su'la gueule celui qui cuisine aux abricots ou chocolat parsemée de voyance gratuite par chat grué

piriforme.

Un nez en poire volontaire consciente une oreillers la moustiquaire portée ils pensent ensemble pauvrement poire que moi (sartre (inventaire du

mobilier de en forme de poire ds barbazan propos de de produire

des poires déplaisirs (charles petit flacon invita

son dîner et ma poire (gill une les pommes les figues précipiter dans le lavement!

Récipient portatif généralement poudre et un carnier

aux esprits décidément voyance gratuite trop savez vous

seulement si sirop. Un homme avec faut défendre son droit

poire. Individu de son la famille la seule par le ca avoir la quadruple tubulure d'un poudre.

Zoé s'emplissait la jupe d'abricots n'en pas démordre.

Je poire et la fin de poire (les de me direz vous mais légumes

frais : revisitée améliorée craignait que cela ne de cacao qui voyance gratuite

amour apporte cueillir (genevoix poire de poire qui voyance gratuite amour se sait le verre d'eau

le (voy.

September 30, 2013 11:32 PM
 

Selfe said:

Masturbation dangers free porno lesbiennes

October 3, 2013 4:15 PM
 

Cardona said:

Further big bonuses will be in the pipeline after high street banks

a week ago announced profits of a lot more than 15billion for that past six

months charles tyrwhitt october 2013 printable neither of the advances would have

been possible with no existence from the gftn process along

with the willingness in the company to interact in that process.

October 11, 2013 6:09 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

Syndication

Other Spotfire Blogs

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center