phisix | Simple PSEi (formerly known as PHISIX) RESTful API hosted on Google AppEngine | GCP library
kandi X-RAY | phisix Summary
kandi X-RAY | phisix Summary
[Mergify Status] Simple PSEi (formerly known as PHISIX) RESTful API hosted on Google AppEngine. Stocks: look up stocks. Symbol Name URL - ALL /stocks.json BDO BDO UNIBANK, INC. /stocks/BDO.json BPI BANK OF THE PHILIPPINE ISLANDS /stocks/BPI.json CHIB CHINA BANKING CORPORATION /stocks/CHIB.json COL COL FINANCIAL GROUP, INC. /stocks/COL.json EW EAST WEST BANKING CORPORATION /stocks/EW.json . Symbol Name URL - ALL /stocks.xml MBT METROPOLITAN BANK & TRUST COMPANY /stocks/MBT.xml PNB PHILIPPINE NATIONAL BANK /stocks/PNB.xml PSE THE PHILIPPINE STOCK EXCHANGE, INC. /stocks/PSE.xml RCB RIZAL COMMERCIAL BANKING CORPORATION /stocks/RCB.xml SECB SECURITY BANK CORPORATION /stocks/SECB.xml .
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Saves data to the datastore
- Get the date for the trading date
- Parses JSON data from the reader
- Parses the ASIA
- Archive all stocks
- Get all stocks
- Register cors filter
- Parse a date from a string
- Print currency code
- Parse a currency code
- Returns the response as a response
- Returns true if Stocks is readable
- Sets the gateway timeout
- Adds the probes to the response
- Find a stock by symbol and trading date
- Sends a response to the client
- Deserialize a stock
- Registers robots filter
- Retrieve all stock with a date
- Retrieves company information for a given symbol
- Find all stocks
- Returns a stock with the given symbol
- Read stocks from content stream
phisix Key Features
phisix Examples and Code Snippets
Community Discussions
Trending Discussions on phisix
QUESTION
hi im trying to scrape stock market data using google sheets
i am trying to get data the PRICE data from here http://phisix-api.appspot.com/stocks/PNB.xml
so in my google sheet i put
=IMPORTXML("http://phisix-api.appspot.com/stocks/PNB.xml","//*[@id='folder2']/div[2]/div[2]/span[2]")
but i just get #NA and do not get any data
i have read that maybe it is not properly parsing the data so i also tried
=index(IMPORTXML("http://phisix-api.appspot.com/stocks/PNB.xml","//*[@id='folder2']"),1,1)
but still no luck
any help would be appreciated
thanks
EDIT: i got the xml path by using google chromes right click -> copy -> copy xpath
...ANSWER
Answered 2021-Jan-11 at 14:35That resource is an XML file and the elements are bound to the namespace http://phisix-api.appspot.com/phisix-stocks
.
QUESTION
I have VBA code that gets the stock price in a loop.
There are stock symbols not found in this API source. It will result to error for those stocks.
I'm using On Error Resume Next
so the VBA code will continue to the next symbol.
My problem is the symbol in error will return a stock price of the last stock symbol not in error.
I would like to make the result blank or zero for the stock symbols in error.
Current Result - the italicized symbols are those that are in error.
Stock Symbol Price
BDO 158.00
ABS 15.80
GREEN 1.87
ALHI 1.87
LAND 1.87
PLC 0.57
LBC 0.57
EVER 0.57
Desired Result - the italicized symbols those that are in error will result or will give return of 0
Stock Symbol Price
BDO 158.00
ABS 15.80
GREEN 1.87
ALHI 0
LAND 0
PLC 0.57
LBC 0
EVER 0
ANSWER
Answered 2020-Jan-01 at 21:19You can always put a conditional check statement based on the error you receive for invalid stocks, if you are getting empty value in myrequest
on invalid stock. You can write your logic like below and update price value to 0.
QUESTION
I have this code that get stock prices. All stock symbols are in a table list, now if the symbol is not in watchlist, its row will be hidden. My challenge now or what I want to achieve is to ignore these hidden rows from getting its stock price. I just want it be simply ignored by the code. Thanks in advance for the help.
Current result is this (those that are "No" in watchlist are hidden rows, but the code still return its price):
Rows Symbol Price Watchlist(Filter)
1 ABS 17 Yes
2 BDO 19 No
3 NIKL 4 Yes
4 TECH 5 No
5 MWC 10 Yes
What I want to achieve is for the code to just ignore those stocks/rows that are hidden from getting the stock price.
Rows Symbol Price Watchlist(Filter)
1 ABS 17 Yes
2 BDO No
3 NIKL 4 Yes
4 TECH No
5 MWC 10 Yes
...ANSWER
Answered 2020-Jan-08 at 15:53You may try the below.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install phisix
You can use phisix like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the phisix component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page