Lost-Spirit
New Member
I am trying to print the yahoo stock finance data in my website. This is the data i grabbed from yql in XML and link to it is Click here for Code generated for XML by Yahoo yql <query yahoo:count="2" yahoo:created="2012-05-12T16:49:14Z" yahoo:lang="en-US"><diagnostics><publiclyCallable>true</publiclyCallable><redirect from="http://datatables.org/alltables.env" status="301">http://www.datatables.org/alltables.env</redirect><url execution-start-time="395" execution-stop-time="790" execution-time="395" proxy="DEFAULT">http://datatables.org/alltables.env</url><url execution-start-time="807" execution-stop-time="1213" execution-time="406" proxy="DEFAULT">http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml</url><url execution-start-time="1452" execution-stop-time="1452" execution-time="0" proxy="DEFAULT">http://download.finance.yahoo.com/d/quotes.csv?f=aa2bb2b3b4cc1c3c6c8dd1d2ee1e7e8e9ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t7t8vv1v7ww1w4xy&s=XAUUSD%3DX,XAGUSD%3DX</url><query execution-start-time="1217" execution-stop-time="1453" execution-time="236" params="{url=[http://download.finance.yahoo.com/d/quotes.csv?f=aa2bb2b3b4cc1c3c6c8dd1d2ee1e7e8e9ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t7t8vv1v7ww1w4xy&s=XAUUSD%3DX,XAGUSD%3DX]}">select * from csv where url=@url and columns='Ask,AverageDailyVolume,Bid,AskRealtime,BidRealtime,BookValue,Change&PercentChange,Change,Commission,ChangeRealtime,AfterHoursChangeRealtime,DividendShare,LastTradeDate,TradeDate,EarningsShare,ErrorIndicationreturnedforsymbolchangedinvalid,EPSEstimateCurrentYear,EPSEstimateNextYear,EPSEstimateNextQuarter,DaysLow,DaysHigh,YearLow,YearHigh,HoldingsGainPercent,AnnualizedGain,HoldingsGain,HoldingsGainPercentRealtime,HoldingsGainRealtime,MoreInfo,OrderBookRealtime,MarketCapitalization,MarketCapRealtime,EBITDA,ChangeFromYearLow,PercentChangeFromYearLow,LastTradeRealtimeWithTime,ChangePercentRealtime,ChangeFromYearHigh,PercebtChangeFromYearHigh,LastTradeWithTime,LastTradePriceOnly,HighLimit,LowLimit,DaysRange,DaysRangeRealtime,FiftydayMovingAverage,TwoHundreddayMovingAverage,ChangeFromTwoHundreddayMovingAverage,PercentChangeFromTwoHundreddayMovingAverage,ChangeFromFiftydayMovingAverage,PercentChangeFromFiftydayMovingAverage,Name,Notes,Open,PreviousClose,PricePaid,ChangeinPercent,PriceSales,PriceBook,ExDividendDate,PERatio,DividendPayDate,PERatioRealtime,PEGRatio,PriceEPSEstimateCurrentYear,PriceEPSEstimateNextYear,Symbol,SharesOwned,ShortRatio,LastTradeTime,TickerTrend,OneyrTargetPrice,Volume,HoldingsValue,HoldingsValueRealtime,YearRange,DaysValueChange,DaysValueChangeRealtime,StockExchange,DividendYield'</query><javascript execution-time="262" instructions-used="108360" table-name="yahoo.finance.quotes"/><user-time>1478</user-time><service-time>801</service-time><build-version>27222</build-version></diagnostics><results><quote symbol="XAUUSD=X"> <Ask>1575.30</Ask> <AverageDailyVolume>0</AverageDailyVolume> <Bid>1585.30</Bid> <AskRealtime/> <BidRealtime/> <BookValue/> <Change_PercentChange>N/A - N/A</Change_PercentChange> <Change/> <Commission/> <ChangeRealtime>0.00</ChangeRealtime> <AfterHoursChangeRealtime>N/A - N/A</AfterHoursChangeRealtime> <DividendShare/> <LastTradeDate>5/11/2012</LastTradeDate> <TradeDate/> <EarningsShare/> <ErrorIndicationreturnedforsymbolchangedinvalid/> <EPSEstimateCurrentYear/> <EPSEstimateNextYear/> <EPSEstimateNextQuarter/> <DaysLow/> <DaysHigh/> <YearLow/> <YearHigh/> <HoldingsGainPercent>- - -</HoldingsGainPercent> <AnnualizedGain/> <HoldingsGain/> <HoldingsGainPercentRealtime>N/A - N/A</HoldingsGainPercentRealtime> <HoldingsGainRealtime/> <MoreInfo/> <OrderBookRealtime/> <MarketCapitalization/> <MarketCapRealtime/> <EBITDA/> <ChangeFromYearLow/> <PercentChangeFromYearLow/> <LastTradeRealtimeWithTime>N/A - <b>1580.3002</b></LastTradeRealtimeWithTime> <ChangePercentRealtime>N/A - 0.00%</ChangePercentRealtime> <ChangeFromYearHigh/> <PercebtChangeFromYearHigh/> <LastTradeWithTime>May 11 - <b>1580.3002</b></LastTradeWithTime> <LastTradePriceOnly>1580.3002</LastTradePriceOnly> <HighLimit/> <LowLimit/> <DaysRange>N/A - N/A</DaysRange> <DaysRangeRealtime>N/A - N/A</DaysRangeRealtime> <FiftydayMovingAverage/> <TwoHundreddayMovingAverage/> <ChangeFromTwoHundreddayMovingAverage/> <PercentChangeFromTwoHundreddayMovingAverage/> <ChangeFromFiftydayMovingAverage/> <PercentChangeFromFiftydayMovingAverage/> <Name>XAU to USD</Name> <Notes/> <Open/> <PreviousClose/> <PricePaid/> <ChangeinPercent/> <PriceSales/> <PriceBook/> <ExDividendDate/> <PERatio/> <DividendPayDate/> <PERatioRealtime/> <PEGRatio/> <PriceEPSEstimateCurrentYear/> <PriceEPSEstimateNextYear/> <Symbol>XAUUSD=X</Symbol> <SharesOwned/> <ShortRatio/> <LastTradeTime>5:15pm</LastTradeTime> <TickerTrend/> <OneyrTargetPrice/> <Volume/> <HoldingsValue/> <HoldingsValueRealtime/> <YearRange>N/A - N/A</YearRange> <DaysValueChange>- - 0.00%</DaysValueChange> <DaysValueChangeRealtime>N/A - N/A</DaysValueChangeRealtime> <StockExchange/> <DividendYield/> <PercentChange>N/A</PercentChange></quote><quote symbol="XAGUSD=X"> <Ask/> <AverageDailyVolume>0</AverageDailyVolume> <Bid/> <AskRealtime/> <BidRealtime/> <BookValue/> <Change_PercentChange>N/A - N/A</Change_PercentChange> <Change/> <Commission/> <ChangeRealtime>0.00</ChangeRealtime> <AfterHoursChangeRealtime>N/A - N/A</AfterHoursChangeRealtime> <DividendShare/> <LastTradeDate>5/11/2012</LastTradeDate> <TradeDate/> <EarningsShare/> <ErrorIndicationreturnedforsymbolchangedinvalid/> <EPSEstimateCurrentYear/> <EPSEstimateNextYear/> <EPSEstimateNextQuarter/> <DaysLow/> <DaysHigh/> <YearLow/> <YearHigh/> <HoldingsGainPercent>- - -</HoldingsGainPercent> <AnnualizedGain/> <HoldingsGain/> <HoldingsGainPercentRealtime>N/A - N/A</HoldingsGainPercentRealtime> <HoldingsGainRealtime/> <MoreInfo/> <OrderBookRealtime/> <MarketCapitalization/> <MarketCapRealtime/> <EBITDA/> <ChangeFromYearLow/> <PercentChangeFromYearLow/> <LastTradeRealtimeWithTime>N/A - <b>28.858</b></LastTradeRealtimeWithTime> <ChangePercentRealtime>N/A - 0.00%</ChangePercentRealtime> <ChangeFromYearHigh/> <PercebtChangeFromYearHigh/> <LastTradeWithTime>May 11 - <b>28.858</b></LastTradeWithTime> <LastTradePriceOnly>28.858</LastTradePriceOnly> <HighLimit/> <LowLimit/> <DaysRange>N/A - N/A</DaysRange> <DaysRangeRealtime>N/A - N/A</DaysRangeRealtime> <FiftydayMovingAverage/> <TwoHundreddayMovingAverage/> <ChangeFromTwoHundreddayMovingAverage/> <PercentChangeFromTwoHundreddayMovingAverage/> <ChangeFromFiftydayMovingAverage/> <PercentChangeFromFiftydayMovingAverage/> <Name>XAG to USDZ 999 N</Name> <Notes/> <Open/> <PreviousClose/> <PricePaid/> <ChangeinPercent/> <PriceSales/> <PriceBook/> <ExDividendDate/> <PERatio/> <DividendPayDate/> <PERatioRealtime/> <PEGRatio/> <PriceEPSEstimateCurrentYear/> <PriceEPSEstimateNextYear/> <Symbol>XAGUSD=X</Symbol> <SharesOwned/> <ShortRatio/> <LastTradeTime>5:35pm</LastTradeTime> <TickerTrend/> <OneyrTargetPrice/> <Volume/> <HoldingsValue/> <HoldingsValueRealtime/> <YearRange>N/A - N/A</YearRange> <DaysValueChange>- - 0.00%</DaysValueChange> <DaysValueChangeRealtime>N/A - N/A</DaysValueChangeRealtime> <StockExchange/> <DividendYield/> <PercentChange>N/A</PercentChange></quote>I want to do something like this from the XML <?phpSession_Start();$_Session['Ask'] = $Ask;$_Session['Bid'] = $Bid;$_Session['AskRealtime'] = $AskRealtime;$_Session['BidRealtime'] = $BidRealtime;$_Session['LastTradeDate'] = $LastTradeDate;$_Session['LastTradePriceOnly'] = $LastTradePriceOnly;$_Session['LastTradeTime'] = $LastTradeTime;?><body><div> <ul> <li><?php echo $_Session['Ask'];?></li> <li><?php echo $_Session['Bid'];?></li> <li><?php echo $_Session['AskRealtime'];?></li> <li><?php echo $_Session['BidRealtime'];?></li> <li><?php echo $_Session['LastTradeDate'];?></li> <li><?php echo $_Session['LastTradePriceOnly'];?></li> <li><?php echo $_Session['LastTradeTime'];?></li> </ul></div></body>