[HN Gopher] Show HN: StonksGPT - A Natural Language search tool ...
       ___________________________________________________________________
        
       Show HN: StonksGPT - A Natural Language search tool for Stocks and
       Finance data
        
       Author : vthallam
       Score  : 107 points
       Date   : 2023-06-01 14:08 UTC (8 hours ago)
        
 (HTM) web link (stonks.news)
 (TXT) w3m dump (stonks.news)
        
       | alexei_rudak wrote:
       | Tried your service. Once I sent my question and got the answer
       | it's not possible to enter another request in the search field.
       | Possible a bug ?
        
         | vthallam wrote:
         | Are you on mobile or web? I just checked, once you enter a
         | prompt, you can clear it and then enter a new one. Happy to
         | help look in more detail if you continue to get this error.
         | feel free me to also email at venk at stonks dot news
        
       | epolanski wrote:
       | "compare the earnings of AAP today and ten years ago" didn't
       | really return much.
       | 
       | Interesting idea though.
        
         | vthallam wrote:
         | Currently only have 5 years data :/ , but plan to expand the
         | data set a bit later!
        
       | anonu wrote:
       | Q: PE ratio of NVDA A: stock price chart of NVDA...
       | 
       | needs some work folks.
        
       | sroussey wrote:
       | So how does this work?
       | 
       | "Top 10 technology stocks by marketcap" for example.
       | 
       | I can see how it can take technology stocks when looking at the
       | whole sentence and use that for a vector search. How do you pull
       | things like "top 10"and turn that into a query?
        
         | downrightmike wrote:
         | SELECT TOP(10) STOCK_NAME FROM STOCKS ORDER BY DESC
        
           | sroussey wrote:
           | Haha, that's not even SQL.
           | 
           | But I am interested in how it turns the request into SQL (if
           | that's what it does).
        
             | lgas wrote:
             | Typically you feed the schema in as context and literally
             | just ask the model to turn it into SQL. So a prompt of the
             | format "Given this schema {schema}, turn this query into
             | SQL. {query}. Return the SQL and nothing else."
        
               | sroussey wrote:
               | I would guess a codex llm would do that, but hopefully
               | the question by the user doesn't end up being a delete
               | statement, lol.
        
               | sroussey wrote:
               | Or perhaps create a lot of "known" queries as templates
               | with good paragraph explanations and use the question to
               | do a search for the known query. I'm new to AI so curious
               | how it's best utilized.
        
             | woadwarrior01 wrote:
             | > Haha, that's not even SQL.
             | 
             | It is in the MSSQL[1] world. I haven't touched it in ~20
             | years and I can still recognise it.
             | 
             | [1]: https://learn.microsoft.com/en-
             | us/sql/t-sql/queries/top-tran...
        
               | sroussey wrote:
               | Interesting! I haven't felt with MSSql since the early
               | 1990s. And I didn't know the TOP(10) even back then I
               | would guess.
               | 
               | Does it also let you not name what you are sorting on?
        
       | marban wrote:
       | https://biztoc.com also has an approved ChatGPT plugin for
       | finance news.
        
       | jmartens wrote:
       | How is this #2 on the front page? It doesn't do anything! I typed
       | in a question, no answer. I typed in a public company name, no
       | answer.
        
         | [deleted]
        
         | vthallam wrote:
         | Hey! Thanks for trying and Sorry it didn't work for you. I had
         | to either build in vaccum with a lot of guessed training data
         | or release a reasonably working tool, so i opted for later.
         | 
         | Things will definitely improve over time, names and tickers
         | should at least give you a chart though! would love to know
         | your prompts either here or email me at venk at stonks dot news
        
       | [deleted]
        
       | rchaud wrote:
       | All the stock and finance data one needs is in earnings statement
       | PDFs stored on the regulators website.
       | 
       | Why isn't there an AI product that can pull every PDF data table
       | and provide the key ratio calculations? That's by far the most
       | time consuming thing about analyzing earnings reports.There are
       | computerized services that have done this for years but that
       | costs money and is not AI-powered.
       | 
       | Shouldn't this be the first thing to be automated in the world of
       | investment research?
        
         | vthallam wrote:
         | This is under development, We already parse form 4's to
         | generate insider transactions and are going to do the same for
         | 10Q's and 10K's very soon. If you are interested in sharing
         | more feedback on what you would want, please reach out to me at
         | venk at stonks dot news
        
         | nologic01 wrote:
         | > Shouldn't this be the first thing to be automated in the
         | world of investment research?
         | 
         | People generally don't like to dig their own information graves
         | so to speak.
         | 
         | Reducing information asymmetries is not the objective of
         | investment research or finance more generally. The only
         | objective is to profitably intermediate financial activity. It
         | generally helps if the clients are not particularly information
         | technology savvy.
         | 
         | Having said that, the obscurity-by-PDF moat looks like its
         | drying up fast.
        
         | jsight wrote:
         | Shouldn't it be able to get the XBRL instead of the PDFs?
        
       | canogat wrote:
       | With a name like Stonks, the audience isn't supposed to take this
       | seriously, right?
        
         | NotYourLawyer wrote:
         | Yeah but it's got AI. So you know it's good.
        
       | karaterobot wrote:
       | I entered a very reasonable query, "what stock should I buy (to
       | get rich as hell)", and there were no useful results. Hopefully
       | this will be fixed when it is officially released!
        
       | yreg wrote:
       | Hi, congrats on your project. I've noticed some things:
       | 
       | - Since this doesn't seem to be made to deal with long complex
       | prompts, I think enter should submit the query instead of adding
       | a new line
       | 
       | - If I ask for something it doesn't know (e.g. spacex marketcap)
       | I get a message explaining that the AI doesn't know that. So far
       | so good. However, when I type into the box after that, that
       | message changes on each keyDown.
       | 
       | edit: Now it seems to be down (error 429 in the console), but
       | there is no error message in the frontend. There should be some
       | explanation to the user :)
        
         | vthallam wrote:
         | Thank you! I initially had a single line, but on mobile it was
         | very awkward to edit text and considering there's no app,
         | figured its easier to have elongated text. Also, adding support
         | for longer queries, essentially like if you have a hypothesis,
         | you could validate it a bit using this tool!
         | 
         | > However, when I type into the box after that, that message
         | changes on each keyDown.
         | 
         | thanks for flagging, will fix it soon!
        
           | yreg wrote:
           | I would personally prefer to submit the query with ENTER and
           | add new lines with SHIFT + ENTER, like in e.g. Slack. (Not on
           | mobile though, of course.)
        
       | starbugs wrote:
       | Looks really nice. Also, excellent name.
        
       | littlestymaar wrote:
       | I love how people continue to use the GPT acronym despite the
       | trademark attempt by OAI, trademark are worthless if not enforced
       | and if the word becomes generic in its usage, so continuing to
       | use GPT to talk about transformer-based generative model is
       | actually harming the trademark grab.
        
       | Triangle9349 wrote:
       | crypto? dude from mcdonalds said OrangutanCoin is the future!
        
         | [deleted]
        
       | DesiLurker wrote:
       | I hear about so many AI powered stockpicking in the investing
       | space that I am even more firmly convinced that just investing in
       | broad indexes like S&P 500 is the only move left for retail
       | investor. pretty much all the alpha is going to squeezed out even
       | if a small number of these efforts are successful.
        
         | __loam wrote:
         | I would be shocked if these things outperformed index funds.
        
           | yreg wrote:
           | AI high frequency traders often outperform index funds.
           | Different kind of AI though. (Although AFAIK some do measure
           | public sentiment through language analysis and use it as one
           | of the inputs.)
        
       | m3kw9 wrote:
       | Hey look, more ways to confirm bias and lose money.
        
       | exabrial wrote:
       | > show me nancy pelosi's options positions right now
       | 
       | Dang. I wanted to be a billionaire too.
        
         | vthallam wrote:
         | don't have politicians data yet haha! but I plan to add it in
         | the next week:)
        
           | djbusby wrote:
           | Why? Their data is like three months behind. Is that still
           | actionable?
        
             | NickC25 wrote:
             | Somewhat. If the options are long-dated, I don't see why
             | they wouldn't be? If Pelosi has calls or puts that are
             | dated a year from now, might make sense to follow the trade
             | if it's a well known company that does business with the
             | government.
        
       | 29athrowaway wrote:
       | If I was you I would talk to a lawyer to discuss the legal
       | implications of this.
        
       | TheRoque wrote:
       | All my requests fail beyond the proposed prompts, and the
       | "random". I asked "show me the chart of SP500 over the last 3
       | months" and it didn't work. Could you give a rough idea of the
       | scope as of now ?
        
         | vthallam wrote:
         | Thanks for trying and Sorry! It's super early, what works
         | great:
         | 
         | * Screener type queries * Charting(prices, volumes), single
         | company or comparing multiple * Insider transactions from any
         | company * heatmap or top movers today * Earnings data for a
         | certain year and quarter.
         | 
         | There's a bunch of things that also work, but overall we have a
         | long way to go! Please do sign up so we could update you on the
         | next set of features
        
           | TheRoque wrote:
           | Thanks for the answer. I signed up and will check it once in
           | a while ! Good luck.
        
       | brentis wrote:
       | 0 for 5 questions. I gave up.
        
       | kk58 wrote:
       | App doesn't work at all
        
       | KerryJones wrote:
       | I tried typing in a ticker symbol "ozk" and it had nothing. I
       | tried typing the full name, "Bank of the Ozarks" and it got
       | nothing. I understand it's looking for natural language, but I
       | would expect business names to pull up something?
        
         | vthallam wrote:
         | Sorry, sometimes its just dumb. it works like this -
         | https://stonks.news/gpt-share/4735/ozk
        
       | scottiebarnes wrote:
       | Asked for a PE ratio graph but didn't work, gave me a price only
       | graph
        
       | throwaway743 wrote:
       | It'd be great if it worked outside of the provided prompts
        
       | simonbutt wrote:
       | Q: "Tell me about Stonks GPT?"
       | 
       | A: "Stonks GPT is a trading name for Stocks & Breads, a UK-based
       | provider of bread and breakfast products. The company was founded
       | in 1894 and is headquartered in London. It is a leading provider
       | of bread products in the UK, with a portfolio of over 50 brands.
       | Stonks GPT is a subsidiary of Unilever PLC, which owns the brands
       | including Pepperidge Farm, Lipton, and Marmite. The company's
       | core business is the production of bread and breakfast products,
       | with a focus on quality and freshness."
       | 
       | There are a lot of hallucinations here. Recommend really
       | specifying in the prompt that if it doesn't know or is unsure,
       | say that and don't make up facts. Understand it's alpha rn and
       | this is all free UAT but for trading related products, accuracy
       | and trust in the product is vital
        
         | l33t233372 wrote:
         | Is it it even technically for the model to know it's
         | hallucinating?
        
           | simonbutt wrote:
           | You won't catch everything but I've found if you specify that
           | it's okay to respond that it doesn't know the answer and
           | essentially accuracy on a smaller subset of answers >
           | responding to all, it often will say it doesn't know rather
           | than making something up.
           | 
           | Another option could be - assuming this is an LLMChain that
           | adds the most similar (n) embedding(s) to the prompt before
           | passing to LLM - basic entity recognition to find the asset
           | name from the query initially and dynamic prompt that if the
           | most similar results don't contain the asset name, don't
           | provide examples and respond saying you don't know.
        
             | __loam wrote:
             | So no then
        
           | jsight wrote:
           | I feel like "hallucinating" is the wrong word. It is
           | essentially predicting the next word based upon its neural
           | net and training. If this training does not have the right
           | data, it will predict things that are wrong.
           | 
           | While knowing might be impossible, it seems like the model
           | could provide a confidence level and only provide answers
           | that exceed some threshold. It'd be a bit like asking a human
           | "are you sure about that?"
           | 
           | And in practice, I really don't think it is that different.
           | We humans effectively make things up all the time. Sometimes
           | we are well aware of our educated guesses and sometimes we
           | are less aware.
           | 
           | It isn't realistic to expect an artificial intelligence to be
           | vastly better than human intelligence in this regard.
        
             | yreg wrote:
             | The catch is that the models don't have confidence. They
             | cannot distinguish between knowing something for sure,
             | guessing something and hallucinating false knowledge.
             | 
             | Perhaps researchers will find some clever solution to
             | mitigate this, but for now hallucinating is a pretty good
             | word precisely because the model doesn't give confidence.
        
               | T-A wrote:
               | The Internal State of an LLM Knows When its Lying
               | 
               | https://arxiv.org/abs/2304.13734
        
           | [deleted]
        
       | spyder wrote:
       | Hugged to death? Console shows: 429 (Too Many Requests)
        
       | zukzuk wrote:
       | "which stocks listed on the TSX are most closely correlated with
       | real estate prices"
       | 
       | First result was "Plantir (PLTR)"
       | 
       | -\\_(tsu)_/-
        
       ___________________________________________________________________
       (page generated 2023-06-01 23:02 UTC)